Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate with years....?
Hi Andrew
I do most humbly apologise. I must learn to read first and post second!!<bg Just as I hit the send button, I reread your posting and saw that you wanted to add 12 years to 16/11/1993, not find the number of years between the two. =DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1)) -- Regards Roger Govier "Roger Govier" wrote in message news:... Hi Andrew Then you can't have 16/11/1993 in A1 If I have A1 blank then I get 105 in both cases. You are seeing 14/apr/1900 because your cell is formatted as date and 14/04/1900 is 105 days after 01/01/1900. Format the cell as general and you will see 105 in both cases. Enter 16/11/1993 in A1 and you will see 12 and 11, the answer of 11 being because we have not yet reached 16/11/2005 so we are still about 6 weeks short of 12 years. -- Regards Roger Govier "Andrew" <NoToSPAM@home wrote in message ... These Either return: Sat-14/Apr/1900 Or 105 Not.... 16/12/2005 ....? Sorry Roger your Not answering the question. Thanx for trying though. "Roger Govier" wrote in message ... | Hi | | One way | =YEAR(TODAY())-YEAR(A1) | or | =DATEDIF(a1,TODAY(),"y") | | | -- | Regards | | Roger Govier | | | "Andrew" <NoToSPAM@home wrote in message | ... | How to calculate with years... | | IE: Date in Cell(A1) 16/12/1993 | Value in B(1)= 12 (Years) | | should give date 16/12/2005 | ------------------- | TIA | Andrew | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate # of years | Excel Worksheet Functions | |||
Calculate Age in Years and Months? | New Users to Excel | |||
How to calculate with years....? | Excel Programming | |||
How to calculate with years....? | Excel Programming | |||
calculate number of years | New Users to Excel |