Previous Topic Next Topic

Excel Formula to add DAY in cell from DATE

Closed
Laing - Jun 9, 2015 at 04:55 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 11, 2015 at 11:31 AM
Hello,

Is it possible to have a formula that automatically adds the day to a cell if a date is entered into another cell.

For example, Column A is for the days and column B is for dates, if I enter 09/06/2015 into cell B1 is there a formula for cell A1 that can automatically add the day?

Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 11, 2015 at 11:31 AM
Hi Laing,

You don't need a formula for that. Just adjust the format of the cell. To do this, select column A > CTRL+1 > Numbers tab > manual input either D, DD, DDD or DDDD.

Good luck,
Trowa
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response