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

Find more posts tagged with

SAVE $250 on Your Boot Camp — Use Code "EXAM26"

Exclusively for TechExams members for Infosec Boot Camps starting before April 30, 2026

View Boot Camps

Comments

dadaji

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

Assuming A1 contained 03/30/2009

=DATEDIF(A1,TODAY(),"M")

dadaji

My bad, I didn't read the question properly, I thought he wanted the age in years.

qwertyiop

Thanks, that worked

RobertKaucher

dadaji wrote: »

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.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of