MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Adding a month to a date to display the next month?

Posted by Scott on June 21, 2001 8:22 AM

Is there a way to add a month to a date? I have labels set up for a sheet that shows imported forecast information and need to retype the labels every month.

=TODAY() is formatted to show Jun or the current month (That part works)
for the 5 cells to the right, I need =(today())+1month

I tried adding days and that works but not every day of every month.



Posted by IML on June 21, 2001 8:32 AM


If you get an error, you may need the analys add in.
good luck.