General discussion


Adding a date formula into Excel

By curtkiesling ·
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] ?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Adding a date formula into Excel

by DKlippert In reply to Adding a date formula int ...

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:

Related Discussions

Related Forums