Calculate # of years
 

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!

Calculate # of years
 

=DATEDIF(A1,TODAY(),"Y")
--
Gary''s Student - gsnu201001


"JT" wrote:

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!

Calculate # of years
 

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

"Gary''s Student" wrote:

=DATEDIF(A1,TODAY(),"Y")
--
Gary''s Student - gsnu201001


"JT" wrote:

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!

Calculate # of years
 

Hi,

Try this in cell C1

=year(today())-2005

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"JT" wrote in message
...
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!

Calculate # of years
 

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" wrote in message
...
Sorry...but I'm confused by the formula. Can you "dumb it down" a bit for
me?

"Gary''s Student" wrote:

=DATEDIF(A1,TODAY(),"Y")
--
Gary''s Student - gsnu201001


"JT" wrote:

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!

Calculate # of years
 

Ashish:

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

"Ashish Mathur" wrote:

Hi,

Try this in cell C1

=year(today())-2005

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"JT" wrote in message
...
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!

Calculate # of years
 

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

Regards,
Fred

"JT" wrote in message
...
Ashish:

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

"Ashish Mathur" wrote:

Hi,

Try this in cell C1

=year(today())-2005

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"JT" wrote in message
...
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!