"ertug" wrote in message
...


"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)))