Calculate # of years

[JT]

I need to be able to calculate the estimated age of a piece of equipment
beginning at it's construction date. For example:

Air Handler "A" was built in 2005. I need Cell C1 to tell me the number of
years since that date...and have the cell update each year into the future.

Help is greatly appreciated!

 

[Gary''s Student]

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

 

[JT]

Sorry...but I'm confused by the formula. Can you "dumb it down" a bit for me?

 

[Ashish Mathur]

Hi,

Try this in cell C1

=year(today())-2005

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Fred Smith]

Your problem is you didn't give enough detail for a specific response.

"Air Handler "A" was built in 2005". Is this a year, or a date? What cell is
it in? Gary assumed you had a date, mostly because you said you have the
"construction date". As you didn't specify the cell, he used A1 as the
example. He assumed you would be able to adjust it to suit your situation.
If you have the number 2005 in a cell (say a1), use:
=year(today())-a1

You put this formula in C1 as that's where you said you wanted the result.

If you need more detail, post back with what cell the data is in, and what
the cell contains.

Regards,
Fred

 

[JT]

Ashish:

Forgive me but I'm not sure what goes inside the two parenthesis (). Can
you explain?

 

[Fred Smith]

Nothing. That's why Ashish showed it that way. What happened when you tried
it?

Regards,
Fred