Function to caculate date
 

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

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

www.OfficeArticles.com


"Jen" wrote in message
...
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

"Jen" wrote
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)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

=a1+60
(Format it as a date)

For the second question.

Jen wrote:

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

--

Dave Peterson