View Single Post
  #6   Report Post  
Fred Smith
 
Posts: n/a
Default

To add one month to a previous date, use:

=date(year(a1),month(a1)+1,day(a1))

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Jason" wrote in message
...
Basically I need to be able to add 1 month to a previous date.

"Jason" wrote:

i'm working on an amortization spread sheet and i need to have the
individual
due dates calculated the same way they are in the web examples.