Need help from a Excel Formula Guru
I have a hardware list and in it I have the purchase date and need to know the Age in months. How would I do that?
Ex.
Puchased Age
7/11/2006
Ex.
Puchased Age
7/11/2006
Comments
-
dadaji Member Posts: 96 ■■□□□□□□□□Suppose today's date is in cell A1 and the purchase date is in cell A2, try the formula (A1-A2)/365.25
I think that should work. -
RobertKaucher Member Posts: 4,299 ■■■■■■■■■■Assuming A1 contained 03/30/2009
=DATEDIF(A1,TODAY(),"M")
-
dadaji Member Posts: 96 ■■□□□□□□□□My bad, I didn't read the question properly, I thought he wanted the age in years.
-
RobertKaucher Member Posts: 4,299 ■■■■■■■■■■My bad, I didn't read the question properly, I thought he wanted the age in years.
You could still do that with datediff. Just put in Y rather than M. Same basic thing, just a little clearer and does not require a column to have the current date.