Discussion How to calculate time between two dates. What replaces datedif? in Excel
https://techcommunity.microsoft.com/t5/excel/how-to-calculate-time-between-two-dates-what-replaces-datedif/m-p/3299782#M144697
<P>I need to calculate age in years between two dates. Help says use datedif, but the function does not appear in excel! I know there is a way to create a function that does this, but I haven't the algebraic ability.</P><P>Can someone help me with a formula?</P>Sun, 01 May 2022 14:26:12 GMTLisainnj2022-05-01T14:26:12ZHow to calculate time between two dates. What replaces datedif?
https://techcommunity.microsoft.com/t5/excel/how-to-calculate-time-between-two-dates-what-replaces-datedif/m-p/3299782#M144697
<P>I need to calculate age in years between two dates. Help says use datedif, but the function does not appear in excel! I know there is a way to create a function that does this, but I haven't the algebraic ability.</P><P>Can someone help me with a formula?</P>Sun, 01 May 2022 14:26:12 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-calculate-time-between-two-dates-what-replaces-datedif/m-p/3299782#M144697Lisainnj2022-05-01T14:26:12ZRe: How to calculate time between two dates. What replaces datedif?
https://techcommunity.microsoft.com/t5/excel/how-to-calculate-time-between-two-dates-what-replaces-datedif/m-p/3299783#M144698
<P><a href="https://techcommunity.microsoft.com/t5/user/viewprofilepage/user-id/1378175">@Lisainnj</a> Which version of Excel are you using, on which platform? It is available in most versions, but not well documented in some of them.</P>
<P>Let's say you have dates in A2 and B2. Try entering =DATEDIF(A2,B2,"y") in another cell.</P>Sun, 01 May 2022 14:31:19 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-calculate-time-between-two-dates-what-replaces-datedif/m-p/3299783#M144698Hans Vogelaar2022-05-01T14:31:19ZRe: How to calculate time between two dates. What replaces datedif?
https://techcommunity.microsoft.com/t5/excel/how-to-calculate-time-between-two-dates-what-replaces-datedif/m-p/3299796#M144701
<P><a href="https://techcommunity.microsoft.com/t5/user/viewprofilepage/user-id/1378175">@Lisainnj</a> </P>
<P>In addition, there is no tooltip for DATEDIF(). You shall type it on your own, Excel shows nothing while you are entering function.</P>
<P>Alternatively you may use <A href="https://support.microsoft.com/en-us/office/yearfrac-function-3844141e-c76d-4143-82b6-208454ddc6a8" target="_blank">YEARFRAC function (microsoft.com)</A></P>Sun, 01 May 2022 15:23:44 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-calculate-time-between-two-dates-what-replaces-datedif/m-p/3299796#M144701Sergei Baklan2022-05-01T15:23:44ZRe: How to calculate time between two dates. What replaces datedif?
https://techcommunity.microsoft.com/t5/excel/how-to-calculate-time-between-two-dates-what-replaces-datedif/m-p/3299815#M144702
I'm use windows on a remote cloud service I'm subscribed to office 365<BR />the datedif function does not show in excel and will not compute a value - even when i change cells and hand enter the equation example. i need another option to the no longer available functionSun, 01 May 2022 16:19:15 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-calculate-time-between-two-dates-what-replaces-datedif/m-p/3299815#M144702Lisainnj2022-05-01T16:19:15ZRe: How to calculate time between two dates. What replaces datedif?
https://techcommunity.microsoft.com/t5/excel/how-to-calculate-time-between-two-dates-what-replaces-datedif/m-p/3299816#M144703
no tooltip - and when typed, no calculation. thank you for the alternative to use.Sun, 01 May 2022 16:21:02 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-calculate-time-between-two-dates-what-replaces-datedif/m-p/3299816#M144703Lisainnj2022-05-01T16:21:02ZRe: How to calculate time between two dates. What replaces datedif?
https://techcommunity.microsoft.com/t5/excel/how-to-calculate-time-between-two-dates-what-replaces-datedif/m-p/3474085#M149531
This works -- if you follow exactly the correct syntax!Mon, 06 Jun 2022 23:02:00 GMThttps://techcommunity.microsoft.com/t5/excel/how-to-calculate-time-between-two-dates-what-replaces-datedif/m-p/3474085#M149531Gary_Devine2022-06-06T23:02:00Z