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

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:

http://www.ozgrid.com/Excel/ExcelDa...

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

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,

Karen

Ask Your Question

Weekly Poll

Do you think Jony Ive could make a big impact on Airbnb?

Discuss in The Lounge

Poll History