DATES

  • Thread starter Thread starter jody
  • Start date Start date
J

jody

I am trying to perform a simple formula, but I can't figure it out. In cell
A1, I have the date 02-01-2005. I would a formula in A3 to calculate the
date 60 days from A1. For example A1 is 02-01-2005. A3 should be 04-01-2005
Thanks,
 
You don't want plus 60 days you want plus 2 months. Plus 60 days would give
you April 2. Here you go.

=DATE(YEAR(A1),MONTH(A1)+2,DAY(A1))
 
Jody

If 02-01-2005 is February 1, 2005........

60 days from that is April 2, 2005

=A1 + 60


Gord Dibben Excel MVP
 
Back
Top