calculating months without edate

  • Thread starter Thread starter Scot
  • Start date Start date
S

Scot

I have created an amortization table that allows the user the enter a date.
I used edate to identify the months sequentially. I want to post this
spreadsheet to the web and it won't allow me to use edate.

I need to enter a month and year into a cell and then have a column of
months in order for up to 30 years.

Thanks

Scot
 
I have created an amortization table that allows the user the enter a date.
I used edate to identify the months sequentially. I want to post this
spreadsheet to the web and it won't allow me to use edate.

I need to enter a month and year into a cell and then have a column of
months in order for up to 30 years.
Click to expand...

There's always brute force. If you make a date entry in, say, A1, then one month
later in cell A2 would be

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A$1)-IF(DAY(A1+31)<DAY(A1),DAY(A1+31),0))

Fill this formula down into the next 359 cells for 361 entries in total.
 
Back
Top