DATEDIF function (microsoft.com) is practically in any version of Excel, but it is not shown in list of functions (see comment in above support post). Thus simply type in cell =DATEDIF(... XLOOKUP function (microsoft.com) most probably shall be available on all ch...
DateDif() is a long-standing Excel function that returns the duration between two dates. It’s not a ‘full’ Excel function because it was added for compatibility with Lotus 123 and has a known bug. Despite that, DateDif() is really, really useful so it’s widely used see Calculate age...
Hi, I would like to calculate the months between 2 dates, but the datedif function does not seem to work in my version Excel (version 16;68). I'm a Mac user. Can someone plse help me? What should I do? hi sofie, i also tried this function, actually function is not recognized bu...
As I mentioned above, using the "md" unit in the DATEDIF function is not always correct (both in Excel and in Google Sheets). The work-around formula recommended by Microsoft on their support page is wrong even more often. There are two methods for calculating the remaining days, shown be...
Hello, I'm trying to get average age from date of birth in an Excel sheet (Microsoft 365) and the function to be used is datedif but nothing works, I...
Anwendung 'DATEDIF' Funktion Angaben untere "Excel Hilfe" zu 'DATEDIF' funktionieren nicht.Benötige die Befehlsangabe für die Ermittlung einer...
I'm using the excel function =DATEDIF(start_date,TODAY(),"Y") and for each line this function runs under, I'm getting the incorrect value. For...
I'm using Microsoft Office 365.I've discovered the DATEDIF formula in this forum, but it's not to working for me.I've tried several variations and get the...
=ROUND(DATEDIF(A1,B1,"M")+DATEDIF(A2,B2,"Md")/30,1) ROUND function I would be happy to know if I could help. Nikolino I know I don't know anything (Socrates) * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here...
DatedIf Not Working I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. Using the DatedIf function I am attempting to formulate the following: =datedif(mfg_date,expir_date,"m")- this is per every forum I've found. Now when I ...