General discussion


date formulas in excel

By fdesimone ·
i have a cell in worksheet number 1 that has a starting date for the first invoice of 60 subsequent invoices. i need to know how to have the same cell in each invoice calculate the future date based on the sequence of the worksheet. i.e. worksheet #2 would be one month after worksheet number two etc...

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by ComputerCookie In reply to date formulas in excel

Not exactly sure how you intend to set the worksheet out!

However, if you enter the date in sheet1 and format all the ceels in that column as a date all you need to do in sheet2 is enter the following expression in the date column and it will work provide that all thaose cells are formated as a date cell.

=Sheet1!A1+30 for example if the next month was February =Sheet1!A1+28 or 29 in a leap year, or +31 if their are 31days in the next month.

Hope I have explained it well enough

Related Discussions

Related Forums