Function to caculate date

[Guest]

Is there a function that will add one or two months to a date in another cell?
Example: January 30,2005 in cell A1 in cell A2 March 30,2005


Also is there a function that will add a specific number of days?
Example: January 30, 2005 in cell A1 , would like to add 60 days to that

Thank you in advance

 

[Anne Troy]

Try this, Jen:
=DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))
*******************
~Anne Troy

www.OfficeArticles.com

 

[Max]

Is there a function that will add one or two months to a date in another cell?
Example: January 30,2005 in cell A1 in cell A2 March 30,2005

Try in A2: =DATE(YEAR(A1),MONTH(A1)+2,DAY(A1))
(add 2 months)

Also is there a function that will add a specific number of days?
Example: January 30, 2005 in cell A1 , would like to add 60 days to that

Try in A2: =DATE(YEAR(A1),MONTH(A1),DAY(A1)+60)

 

[Dave Peterson]

=a1+60
(Format it as a date)

For the second question.