{communityTitle}","errorMissing":"This message cannot be found","name":"Forum Message Page","section.message-list.title":"Forum Discussion","archivedMessageTitle":"This Content Has Been Archived","section.TqVYTs.title":"Forum Discussion"},"localOverride":false},"CachedAsset:quilt...
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 #NAME? error. Examples: DATEDIF(AB2,AA4,D) DATEDIF("11/09/2020","04/01/2021",D) DATEDIF(AB2,"04/01/2021",D) DATEDIF(...
DATEDIF How do I divide the result of the DATEDIF function? Marwan_Ibrahim Can you explain in more detail what you want to do? Marwan_Ibrahim =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...
Hi every one, I am trying to calculate the age of a lap top from the date of purchase using the formula DateDif has show above. I keep getting an error, so I double check many things, li... Clementje =DATEDIF(C3,TODAY(),"m") It works in my sheet when i enter C3 without " "...
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...
HELLO I HAVE A PROBLEM OF CALCULATION! I USED THE FUNCTION DATEDIF TO FIND THE DIFFERENCE BETWEEN MANY DIFFRENT DATES AND THE RESULT IS THESESONE " ... years...months..days " FOR EACH CALCULATE WHICH IS NORMAL. THE PROBLEM IS THAT I WANT TO USE THE FUNCTION IF SOIF THE VALID IS TRUE...
I want the new cell to have the format "X years Y months" with the number of fulfilled years and months. Cannot get the DATEDIF solution to work (Could it be because of a swedish version of excel - end what is then the right command in swedish?) ...
JCSFergusonThis is what Excel says about DATEDIF Are your start and end dates real dates? Can you upload an example of what you are trying to achieve? Riny_van_Eekelen Hi Riny, thanks so much for taking the time to reply. I've actually since figured out what I've been doing wrong!
I want the new cell to have the format "X years Y months" with the number of fulfilled years and months. Cannot get the DATEDIF solution to work (Could it be because of a swedish version of excel - end what is then the right command in swedish?) ...
Even better second date also have in cell. In general formula shall work. Format doesn't matter, actual values are important. Perhaps you may submit small file similar to above (not screenshot, excel file) to check what's wrong.