scadaman29325
New Member
- Joined
- Oct 13, 2002
- Messages
- 23
When I use:
=DATE(YEAR($D$5),MONTH($D$5),DAY($D$5+1))
across 7 columns (dates for one week)instead of going to a new month it goes back to the first day of the month.
How can I get it to go the the next calendar day in the next month.
=DATE(YEAR($D$5),MONTH($D$5),DAY($D$5+1))
across 7 columns (dates for one week)instead of going to a new month it goes back to the first day of the month.
How can I get it to go the the next calendar day in the next month.