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