Excel Formula to add DAY in cell from DATE Closed

Question

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?

Configuration: Mac OS X (10.9.5) / Chrome 42.0.2311.152

TrowaD · Answer

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

Excel Formula to add DAY in cell from DATE

1 response

Similar discussions

Subscribe To Our Newsletter!