Calculate # of years

J

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!
 
F

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
 
J

JT

Ashish:

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

Fred Smith

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

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Calculate age from DOB in years, months days 7
How do I calculate a persn's age in years & months in Excel? 4
Calculating age from date of birth and ignoring if blank 5
I need help with a Function 0
Calculate elapsed time excluding specific timeframe 10
Calculate Number of years 4
future calue using target value and rate of return 2
"how do I calculate age by using date of birth details" 5

Top