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?

Excel Formula to add DAY in cell from DATE
Date formula in excel dd/mm/yyyy - Guide
Pdf and xps add in 2007 - Download - Other
Number to words in excel formula - Guide
How to add 90 days to a date in excel - Guide
Excel grade formula - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!