Home

Calculate age

%3CLINGO-SUB%20id%3D%22lingo-sub-281196%22%20slang%3D%22en-US%22%3ECalculate%20age%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281196%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20calculate%20age%20with%20DATEDIF.%20In%20exel%20works%20do%20that%20with%20a%20date%20such%20as%20d-mm%2Fdd%2Fyyyy%20format.%20In%20the%20examples%20I%20see%20the%20d%2Fmm%2Fyyyy%20date%20format%20how%20do%20I%20change%20it%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHoe%20kan%20ik%20een%20leeftijd%20berekenen%20met%20datum%20verschil.%3C%2FP%3E%3CP%3EIn%20exel%20werkt%20dat%20niet%20met%20een%20datum%20zoals%20d-mm-jjjj.%3C%2FP%3E%3CP%3EIn%20de%20voorbeelden%20zie%20ik%20de%20datum%20notatie%20d%2Fmm%2Fjjjj%3C%2FP%3E%3CP%3EHoe%20kan%20ik%20dit%20veranderen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-281196%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-281370%22%20slang%3D%22en-US%22%3ERe%3A%20Calculate%20age%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281370%22%20slang%3D%22en-US%22%3E%3CP%3EJan%2C%20in%20Excel%20dates%20are%20just%20sequential%20integer%20number%20starting%20from%201%20which%20is%20Jan%2001%2C%201900.%20Thus%20Nov%2001%2C%202018%20is%20equal%20to%2043374.%20For%20the%20calculations%20it%20doesn't%20matter%20in%20which%20format%20dates%20are%20presented.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20Vitalie%20recommended%20if%20you'd%20like%20to%20have%20the%20age%20in%20form%20like%2037.23%20years%20better%20to%20use%20YEARFRAC.%20If%20in%20form%20like%20%2228%20years%2011%20months%20and%205%20days%22%20-%20better%20DATEDIF%20as%20in%20support%20article.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-281223%22%20slang%3D%22en-US%22%3ERe%3A%20Calculate%20age%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281223%22%20slang%3D%22en-US%22%3EFor%20getting%20the%20age%2C%20I%20would%20recommend%20YEARFRAC.%3CBR%20%2F%3EHow%20to%20and%20examples%20here%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fyearfrac-function-3844141e-c76d-4143-82b6-208454ddc6a8%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fyearfrac-function-3844141e-c76d-4143-82b6-208454ddc6a8%3C%2FA%3E%3C%2FLINGO-BODY%3E
Jan Joosten
New Contributor

How do I calculate age with DATEDIF. In exel works do that with a date such as d-mm/dd/yyyy format. In the examples I see the d/mm/yyyy date format how do I change it

 

Hoe kan ik een leeftijd berekenen met datum verschil.

In exel werkt dat niet met een datum zoals d-mm-jjjj.

In de voorbeelden zie ik de datum notatie d/mm/jjjj

Hoe kan ik dit veranderen

2 Replies
For getting the age, I would recommend YEARFRAC.
How to and examples here:
https://support.office.com/en-us/article/yearfrac-function-3844141e-c76d-4143-82b6-208454ddc6a8

Jan, in Excel dates are just sequential integer number starting from 1 which is Jan 01, 1900. Thus Nov 01, 2018 is equal to 43374. For the calculations it doesn't matter in which format dates are presented.

 

As Vitalie recommended if you'd like to have the age in form like 37.23 years better to use YEARFRAC. If in form like "28 years 11 months and 5 days" - better DATEDIF as in support article.

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies