Software

Ask something
Discussion Locked

Adding a date formula into Excel

0 helpful
1 reply

by curtkiesling

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do I add a date formula into a Excel file that would fill each cell under the first cell with the next day of the month[5/2, 5/3, 5/4] ?

Thanks!

1 reply

by dklippert

Put in the first date and hit Enter. select that date and look at the lower right corner of the selection border. You can pull that "Fill handle" down to fill each cell with the next calendar day.
If your first day is in A1 the formula to add a dayis just =A1+1 enetred in A2 and then copied.
For a good discussion of Date math, go to:

WWW.cpearson.com/excel/datetime.htm

This discussion is closed to new replies.