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.

Thanks,

Scott



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

Scott,
Try
=EDATE(NOW(),1)

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