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?


[TABLE="width: 389"]
<tbody>[TR]
[TD]A [/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]DOE, JANE[/TD]
[TD]08/10/2017[/TD]
[TD]2/28/2018[/TD]
[TD]0.6[/TD]
[/TR]
[TR]
[TD]DOE, JACK[/TD]
[TD]1/10/2017[/TD]
[TD]2/28/2018[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]DOE, JILL[/TD]
[TD]1/11/2016[/TD]
[TD]2/28/2018[/TD]
[TD]2.1[/TD]
[/TR]
[TR]
[TD]DOE, JACOB[/TD]
[TD]1/11/2017[/TD]
[TD]2/28/2018[/TD]
[TD]1.1[/TD]
[/TR]
[TR]
[TD]DOE, JUDE[/TD]
[TD]10/18/2016[/TD]
[TD]2/28/2018[/TD]
[TD]1.4[/TD]
[/TR]
</tbody><colgroup><col><col><col><col></colgroup>[/TABLE]

 

[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