"ertug" <ertug@discussions.microsoft.com> wrote in message
news:37A7EE25-5F76-477F-8273-5695FA05A076@microsoft.com...
>
>
> "devinm21" wrote:
>
>> If I have a person's birthday, how can I calculate their current age
>> based on
>> today's date?
>>
>>
>> Thanks!
>>

In whole years:

=YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))