View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dal1981 Dal1981 is offline
external usenet poster
 
Posts: 2
Default How do I add Months to a date??

Hi,

How do I get Excel to add a certain number of months to a date??

For example if cell A1 I have the date 7th February 2007 and in cell B1 I
had 18 (the number of months I wanted to add)
What formula would I have to put in cell C1 so that it adds 18 months to 7th
February 2007, thus giving the answer 7th August 2008?

Any help would be appreciated!

Thank you & kind regards,

Dal