Function to caculate date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Jen said:
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
Click to expand...

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
Click to expand...

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