Something like this should work

On sheet 2
=DATE(2008,MONTH(Sheet1!A1)+1,1)

"JHC" wrote:

Thanks - I have the date as a field and want to advance it by one month on
each subsequent sheet - is that possible?
--
JHC


"JHC" wrote:

I need to do a sheet for each month with the month in words on each sheet and
the date in figures. Starting with January 2008 I have copied the sheet for
each subsequent month using the edit menu then have to manually change the
date each time. ( I have to do this around 200 times!)
Is there a way to get each copy to automatically change to the next month
when it is copied? For instance with a formula? The date in figures is always
the same day and year - just the month changes each time.
Version of Excel is Office 2003.
--
JHC