MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel- Automatic change of date for 12 months

Posted by Robert Dorr on April 19, 2001 9:33 AM

I have a workbook with a reference (user entered date on one worksheet).
The other worksheets in the workbook have 12 columns with consecutive months in the header rows.

By entering a date on the reference worksheet,(mmmyy)format, I want the months in the other worksheets to be updated using the worksheet reference month as the starting month with each of the adjacent column headers incrementing by one month.

How can I do this please?

Posted by Mark W. on April 19, 2001 9:44 AM

Robert, take a look at the EDATE() function. If
you haven't added the Analysis ToolPak you'll need
to do so to have access to this function.