Solved Automaticaly increment date by 1 on each sheet of a workbook

January 9, 2012 at 09:20:25
Specs: Windows 7
I have a workbook setup for one month of daily calendar/tasks/goals (Sheets 1 to 31) and need to have the date increment by 1 on each subsequent sheet.
My idea was to have a field on Sheet 1 where I would input the first day of the month, i.e. 01/02/12 and have a formula on each sheet that used that information to increment the date field by 1

See More: Automaticaly increment date by 1 on each sheet of a workbook

Report •

January 9, 2012 at 09:54:25
✔ Best Answer
Simply add 1 to each date to increment it by 1.

With 01/02/12 in A1, =A1+1 will return 01/03/2012

Excel stores dates and times in what is known as a "serial number" which represents the number of days (or parts thereof) since 1/1/1900.

As you increment that serial number by 1, you are adding one more day since 1/1/1900.

If you increment that serial number by 0.5, you'll increment that date by 12 hours, or half a day.

To prove this to yourself, enter =NOW(). You'll should see the current date and time.

Now format that cell as a number and you'll see something like 40917.86.

For more on using Dates & Times in Excel, see this site:

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

January 9, 2012 at 10:48:31
Thanks so much - I was making this much more complicated for myself than I needed to. I ended up using =SUM('1'!C68+1), =SUM('1'!C68+2), etc. on each worksheet where C68 is a date cell on the first sheet. Now we can enter the date of whatever month on the first worksheet and all the other sheets update from that. I think writing the problem out helped reboot my brain :)
Thanks again,

Report •
Related Solutions

Ask Question