Excel Formula to add DAY in cell from DATE [Closed]

Report
-
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 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
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
456
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!