Calculate age in years and month or decimal
I use =INT((TODAY()-D9)/365.25) to calculate the age of a person. No one is
under 8 years old so it works fine. The answer is given in years. I want the answer to be give as a decimal (i.e. 14.3). Another request is to have the answer years and months (16 years, 2 months) How can I get either or both of these done? |
Calculate age in years and month or decimal
http://www.cpearson.com/excel/datedif.aspx
-- Gary''s Student - gsnu2007j "HH" wrote: I use =INT((TODAY()-D9)/365.25) to calculate the age of a person. No one is under 8 years old so it works fine. The answer is given in years. I want the answer to be give as a decimal (i.e. 14.3). Another request is to have the answer years and months (16 years, 2 months) How can I get either or both of these done? |
Calculate age in years and month or decimal
Thanks,
Just what I needed. "Gary''s Student" wrote in message ... http://www.cpearson.com/excel/datedif.aspx -- Gary''s Student - gsnu2007j "HH" wrote: I use =INT((TODAY()-D9)/365.25) to calculate the age of a person. No one is under 8 years old so it works fine. The answer is given in years. I want the answer to be give as a decimal (i.e. 14.3). Another request is to have the answer years and months (16 years, 2 months) How can I get either or both of these done? |
All times are GMT +1. The time now is 03:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com