Good Morning All,
I hope everyone is having a Blessed Day.
I am having problem with getting a sequential date across multiple worksheets. The date is in the same cell in all work sheets. For example I have 31 worksheets for everyday of the month. The date is in cell B1 in every worksheet. When I put in the date in Worksheet 01 for the first day of the month I would like all of the dates to follow in sequence in all of the other work sheets.
I started with a this Function:
[code]
=MAX(Sheet01!B:B)+1
[code]
The problem is that the date starts with January 01 1900. As you can see I need it to populate first day of the month (example: August 09, 2009).
I tried the =DATE but it did not work.
Any help would be greatly appreciated
Reverend Daniel
Bookmarks