DATEDIF Difficulties

%3CLINGO-SUB%20id%3D%22lingo-sub-1535885%22%20slang%3D%22en-US%22%3EDATEDIF%20Difficulties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1535885%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20real%20difficulty%20getting%20a%20DATEDIF%20calculation%20to%20work%20and%20hoping%20someone%20might%20be%20able%20to%20help.%20I've%20followed%20various%20online%20guides%20and%20I'm%20using%20the%20basic%20format%26nbsp%3B%3DDATEDIF(B9%2CF9%2C''M'').%20The%20two%20cells%20contain%20dates%20and%20I%20think%20I've%20tried%20every%20way%20of%20formatting%20them%20(currently%20formatted%2021%2F7%2F20).%20But%20whatever%20I%20do%20it%20just%20keeps%20on%20coming%20up%20with%20an%20error%20message%20and%20sending%20me%20to%20a%20website%20about%20avoiding%20broken%20formula%20which%20doesn't%20really%20seem%20to%20have%20any%20specific%20suggestions.%20The%20issue%20seems%20to%20be%20the%20''M''%20part%3F%20But%20don't%20know%20what%20else%20I%20can%20do%20differently!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20massively%20appreciated%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EJoseph%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1535885%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-1535929%22%20slang%3D%22en-US%22%3ERe%3A%20DATEDIF%20Difficulties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1535929%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F735051%22%20target%3D%22_blank%22%3E%40JCSFerguson%3C%2FA%3E%26nbsp%3BThis%20is%20what%20Excel%20says%20about%20DATEDIF%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-07-21%20at%2016.48.45.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206857i9676647DA911BD42%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-07-21%20at%2016.48.45.png%22%20alt%3D%22Screenshot%202020-07-21%20at%2016.48.45.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAre%20your%20start%20and%20end%20dates%20real%20dates%3F%20Can%20you%20upload%20an%20example%20of%20what%20you%20are%20trying%20to%20achieve%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1535972%22%20slang%3D%22en-US%22%3ERe%3A%20DATEDIF%20Difficulties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1535972%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Riny%2C%20thanks%20so%20much%20for%20taking%20the%20time%20to%20reply.%20I've%20actually%20since%20figured%20out%20what%20I've%20been%20doing%20wrong!%20So%20it%20turns%20out%20a%20%22%20on%20the%20keyboard%20is%20not%20the%20same%20as%20typing%20'%20twice......%20Feel%20like%20a%20bit%20of%20a%20plonker.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20for%20wasting%20your%20time!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi all

 

I'm having real difficulty getting a DATEDIF calculation to work and hoping someone might be able to help. I've followed various online guides and I'm using the basic format =DATEDIF(B9,F9,''M''). The two cells contain dates and I think I've tried every way of formatting them (currently formatted 21/7/20). But whatever I do it just keeps on coming up with an error message and sending me to a website about avoiding broken formula which doesn't really seem to have any specific suggestions. The issue seems to be the ''M'' part? But don't know what else I can do differently!

 

Any help would be massively appreciated

Thanks

Joseph

2 Replies
Highlighted

@JCSFerguson This is what Excel says about DATEDIF

Screenshot 2020-07-21 at 16.48.45.png

Are your start and end dates real dates? Can you upload an example of what you are trying to achieve?

Highlighted

@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! So it turns out a " on the keyboard is not the same as typing ' twice...... Feel like a bit of a plonker. 

 

Sorry for wasting your time!