Software

Ask something
Discussion Locked

date formulas in excel

0 helpful
1 reply

by fdesimone

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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...

1 reply

by computercookie

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

This discussion is closed to new replies.