<div>
Hi,<br />
<br />
pls try<br />
if DOB in A2 and your date in B2 then try in C2<br />

<pre><code id="code-20-41969666-1">=INT(YEARFRAC(A2,B2,1))</code></pre>
Regards
</div>


Hi,

pls try
if DOB in A2 and your date in B2 then try in C2


=INT(YEARFRAC(A2,B2,1))

Regards

<div>
Hi,<br />
<br />
If you want actual then pls try below:<br />
DOB in A2, Future Date in B2 and below formula in C2<br />

<pre><code id="code-20-41969705-1">=YEARFRAC(B2,A2,1)</code></pre>
</div>


Hi,

If you want actual then pls try below:
DOB in A2, Future Date in B2 and below formula in C2


=YEARFRAC(B2,A2,1)

<div>
This solution was more of what I was looking for. Thanks to the others that posted.
</div>


This solution was more of what I was looking for. Thanks to the others that posted.

<div>
<div class="content wysiwyg-content">
Based on a date in the future I need to be able to put people into groups based on their date of birth.<br />
<br />
So for example I need to know what a persons age will be on march 4th of this year. The result will need to put out their age at that time on that date.
</div>
</div>


Based on a date in the future I need to be able to put people into groups based on their date of birth.

So for example I need to know what a persons age will be on march 4th of this year. The result will need to put out their age at that time on that date.

excel help

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.