Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-21-2011, 05:41 AM
jamierbooth jamierbooth is offline Calculating age at date Windows XP Calculating age at date Office XP
Novice
Calculating age at date
 
Join Date: Feb 2011
Posts: 4
jamierbooth is on a distinguished road
Default Calculating age at date

I need a formula that will tell me what age someone was on a given date.
I have date of birth in column 1, date of referral in column 2, age on date of referral in column 3.

Thanks world!!
Reply With Quote
  #2  
Old 02-21-2011, 07:45 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Calculating age at date Windows 7 32bit Calculating age at date Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi

The exact formula will depend on how you want the age reported.

In years? Like this:
Code:
=DATEDIF(A2,B2,"y")&" years"
In years and months? Like this:
Code:
=DATEDIF(A2,B2,"y")&" years " & DATEDIF(A2,B2,"ym") &" months"

etc...
Reply With Quote
  #3  
Old 02-22-2011, 03:35 AM
jamierbooth jamierbooth is offline Calculating age at date Windows XP Calculating age at date Office XP
Novice
Calculating age at date
 
Join Date: Feb 2011
Posts: 4
jamierbooth is on a distinguished road
Default

Excellent. Thanks.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating age at date 'Last edit date' markg2 Word 3 12-26-2010 04:27 PM
Calculating age at date Need a date formula MPAVLAS Excel 3 08-12-2010 10:04 PM
Calculating Form Fields in Microsoft Word wubba80 Word 1 06-25-2010 12:42 AM
new appointment date always reverts back to today's date msills Outlook 0 08-24-2007 08:57 AM
Calculating age at date Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft