If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
#5
|
|||
|
|||
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 news 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! |
#6
|
|||
|
|||
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! |
#7
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|