Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

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

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

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.