Thread: Date Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RinTinTin RinTinTin is offline
external usenet poster
 
Posts: 2
Default Date Formula



If 6/1/2008 is in A1, enter the following in A2:
=EOMONTH(A1,0)+1
Copy it to suit the number of amortization periods. The result will always
be the first of the next month.

"Lynn H." wrote:

Trying to figure out the formula for the date in an amorization schedule.

Such as: 6/1/2008 then 7/1/2008

Any help is appreciated. Thanks.