Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want a cell to give how old someone is or how long they have been married
today. It has to show that a child born on 2/20/2000 is 4 years old UNTIL 2/20/2005. That day, it would change to 5. It seems that my calculations round up or something and therefore the information is not accurate but shows them older earlier than their actual birthdate. I am doing this as well for anniversaries, employment, etc. Any info will be great appreciated! Thanks, Cheri |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate Years of Service | Excel Worksheet Functions | |||
Calculate Years/Months Between Dates and then Average | Excel Discussion (Misc queries) | |||
Converting months to years | Excel Worksheet Functions | |||
Help with Years of Service formula.... | Excel Discussion (Misc queries) | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |