Date Formula on each sheet referring to previous sheet

I have a spreadsheet that contains 31 pages. Each sheet contains a cell with the date. Is there a formula that I can use to add a day to the date on the first sheet.
Ie.
sheet one, cell A2 Thursday april 15th, 2010
sheet two, cell A2 =( sheet1 cell A2) +1
sheet three, cell A2 =(sheet1 cell A2) +2

and so on.

Any ideas

I get a #ref error. Is it because of my day, month, date, year format on sheet 1?

Another way to do this, so you don't need to change the sheet reference every time, is to put this function in a module: (Alt-F11, right-click vbaproject, insert > module)

Please Login or Register  to view this content.

Then use this formula to pull the previous sheet's date and add one:

Please Login or Register  to view this content.

I was able to figure it out without the code. but thanks

=Date(2010,4,1) for sheet 1
=(sheet1, date Cell)+1 for sheet 2
etc.
thanks