Copying a date through multiple sheets.

[AlanWade]

Basically, what I am trying to do is my workbook has 12 sheets, 1 for each month. In cell A7 on the first sheet (Jan) I would like to enter 01-01-2009 and then it add a month on each of the sheets. e.g. 01-02-2009 01-03-2009 and so forth. I know I can manually put in the first of the month on each of the sheets, just wondering if it can be automated.

Thanks for your time

Alan

[NBVC]

Put this formula in each sheet

=Date(Year(Sheet1!A7),Month(Sheet1!A7)+1,Day(Sheet1!A7))

then either change the +1 to +2, +3, +4, etc for each respective sheet.

[ChrisMattock]

The below formula will result in the date of Sheet1 plus a month so you could do it like that, but if it is just a case of doing this task once for 12 sheets then I would say the best bet is to do it manually.

=DATE(YEAR(Sheet1!A1),MONTH(Sheet1!A1)+1,DAY(Sheet1!A1))

Let me know if I haven't fully understood what you wanted to do.

EDIT: Beaten to it. Damn. :P

[AlanWade]

Thanks så much for the help, exactly what I wanted.