Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating Age in Excel 1

Status
Not open for further replies.
RAClarke

RAClarke

Instructor
Sep 3, 2001
51
GB
Any ideas on how to calculate a persons age based on their date of birth?
 
Sort by date Sort by votes
If cell A1 is the date born, then paste the following formula in B1, and format cell B1 or (col B) as general

=DATEDIF(A1,NOW(),"Y")&" Years and "&DATEDIF(A1,NOW(),"YM")&" Months"

That should do the trick
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
306
Bijugate
Bijugate
ladyck3
  • Locked
  • Question
Excel 365 - Working with Tables - Calculating data from one worksheet to another. 2
2
Replies
30
Views
470
combo
combo
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
301
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
900
shytott
shytott
renigar
  • Locked
  • Question
Excel Power Query refresh error
Replies
3
Views
697
SoftwareRT
SoftwareRT

Part and Inventory Search

Sponsor

Back
Top