Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What is the formula to calculate Age when I have Date of Birth?
I am trying to create an Age column based on the DOB (Date of Birth). What
is the formula for the Age Column?? |
#2
|
|||
|
|||
Use the DATEDIF function. E.g.,
=DATEDIF(date_of_birth,NOW(),"y") See www.cpearson.com/excel/datedif.htm for more details about DATEDIF. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Katiemcgi" wrote in message ... I am trying to create an Age column based on the DOB (Date of Birth). What is the formula for the Age Column?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format within a cell containing a formula | Excel Discussion (Misc queries) | |||
Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
Date Formula | Excel Discussion (Misc queries) | |||
Date formula | Excel Discussion (Misc queries) | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) |