Calculate Age based on a Past Date of Service

[Manny74]

I need to calculate a customer's age based on their date of birth (for example 8/10/2017) and a past date of service (2/28/2018).
Basically, how old was each customer on 2/28/2018.
What formula would I use?

A	B	C	D
DOE, JANE	08/10/2017	2/28/2018	0.6
DOE, JACK	1/10/2017	2/28/2018	1.0
DOE, JILL	1/11/2016	2/28/2018	2.1
DOE, JACOB	1/11/2017	2/28/2018	1.1
DOE, JUDE	10/18/2016	2/28/2018	1.4

<tbody>
</tbody><colgroup><col><col><col><col></colgroup>

 

[mse330]

You can try either of the below formulas

=DATEDIF(B2,C2,"Y")&" Years, "&DATEDIF(B2,C2,"YM")&" Months, "&DATEDIF(B2,C2,"MD")&" Days"

Or a more simple way

=(C2-B2)/365.25