Excel Formula to add DAY in cell from DATE

[Closed]
Report
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
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?

1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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