Calculate age only when both dates present

[MeredithD26]

I have 2 dates (date of birth (A2), and a start date(B2)) and am trying to calculate age at time of start date. This is the formula I am using to ensure it's only calculated if both dates are present: =IF(AND(B2<>"",A2<>""),(B2-A2)/365.25). However, I want to have the value round down (31 in this case) since it's an age. Any help would be appreciated. Thanks.

DOB	Enroll	Age
3/4/1990​	1/1/2022​	31.83025​
3/5/1997​	1/1/2022​	24.82683​

 

[johnny51981]

Give this a shot:

=IF(AND(B2<>"",A2<>""),ROUNDDOWN((B2-A2)/365.25,0),"")

 

[Eric W]

Welcome to the MrExcel forum!

Try:

Book1
	A	B	C
1	DOB	Enroll	Age
2	3/4/1990	1/1/2022	31
3	3/5/1997	1/1/2022	24
4		1/1/2022
5	5/5/1955
Sheet13

Cell Formulas
Range	Formula
C2:C5	C2	=IF(COUNT(A2:B2)=2,DATEDIF(A2,B2,"y"),"")

 

[MeredithD26]

Give this a shot:

=IF(AND(B2<>"",A2<>""),ROUNDDOWN((B2-A2)/365.25,0),"")

This worked, thank you so much!

 

[MeredithD26]

Welcome to the MrExcel forum!

Try:

Book1
	A	B	C
1	DOB	Enroll	Age
2	3/4/1990	1/1/2022	31
3	3/5/1997	1/1/2022	24
4		1/1/2022
5	5/5/1955
Sheet13

Cell Formulas
Range	Formula
C2:C5	C2	=IF(COUNT(A2:B2)=2,DATEDIF(A2,B2,"y"),"")

This also worked, thank you!