How do I calculate the number of years between 2 dates
Hi
I need to calculate the age of a person so in one cell i have the persons dob and in another cell i have a static date ie, 25/12/06 (i'm british). how do i calculate how old a person born 30/04/73 whould have been on christmas day this year. Thank you. |
How do I calculate the number of years between 2 dates
=DATEDIF(dob,christmas,"Y")
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Leisl" wrote in message ... Hi I need to calculate the age of a person so in one cell i have the persons dob and in another cell i have a static date ie, 25/12/06 (i'm british). how do i calculate how old a person born 30/04/73 whould have been on christmas day this year. Thank you. |
How do I calculate the number of years between 2 dates
If your dob is in A1 and static date in B1
=DATEDIF(A1,B1,"y") see here for information on DATEDIF function http://www.cpearson.com/excel/datedif.htm "Leisl" wrote: Hi I need to calculate the age of a person so in one cell i have the persons dob and in another cell i have a static date ie, 25/12/06 (i'm british). how do i calculate how old a person born 30/04/73 whould have been on christmas day this year. Thank you. |
How do I calculate the number of years between 2 dates
Thank you to both of you. Perfect.
"daddylonglegs" wrote: If your dob is in A1 and static date in B1 =DATEDIF(A1,B1,"y") see here for information on DATEDIF function http://www.cpearson.com/excel/datedif.htm "Leisl" wrote: Hi I need to calculate the age of a person so in one cell i have the persons dob and in another cell i have a static date ie, 25/12/06 (i'm british). how do i calculate how old a person born 30/04/73 whould have been on christmas day this year. Thank you. |
All times are GMT +1. The time now is 01:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com