Calculating age at date

		Microsoft Office Forums > Microsoft Excel > Excel
Calculating age at date

02-21-2011, 07:45 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Calculating age at date

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

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...

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
'Last edit date'	markg2	Word	3	12-26-2010 04:27 PM
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
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 12:38 PM.