JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 595
- Office Version
- 365
- Platform
- Windows
I have this formula =INT((J1-R1)/365) in Q1
J1 has the formula =Today( )
R1 has date of birth (for example 1/1/1970)
When I put in the DOB for 1 person as 8/25/1967 I get the age as 57 (in cell Q1) which is correct as the person will not be 58 till August 25, 2025
But for a person with a DOB of 02/14/1968 I am also getting an age of 57 which should be 56 till 2/14/25 when they turn 57.
It appears that any person with a DOB in February the formula is not working. For someone who has their birthday today (02/05/1970) would mean they are turning 55 today but when I change their date to 02/06/1970 their age stays at 55 when it should be 54.
Thanks in advance for your help
James
J1 has the formula =Today( )
R1 has date of birth (for example 1/1/1970)
When I put in the DOB for 1 person as 8/25/1967 I get the age as 57 (in cell Q1) which is correct as the person will not be 58 till August 25, 2025
But for a person with a DOB of 02/14/1968 I am also getting an age of 57 which should be 56 till 2/14/25 when they turn 57.
It appears that any person with a DOB in February the formula is not working. For someone who has their birthday today (02/05/1970) would mean they are turning 55 today but when I change their date to 02/06/1970 their age stays at 55 when it should be 54.
Thanks in advance for your help
James