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.
Re: Adding a month to a date to display the next month?Posted by IML on June 21, 2001 8:32 AM
If you get an error, you may need the analys add in.
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.