Using the Top Secret DATEDIF Function in Excel

[barryfraser]

Nice clean presentation! Thanks!. A tip I figured out: If you add &"M " after the last closed parenthesis, the result will display the resulting number with an 'M', if you then add a comma ampersand and write the same code for days as you explained and type &"d" then the result will be a tidy 2m 20d for example. I use this all the time.

1/1/23 to 2/1/23 + =DATEDIF(B1, C1, "M")&"m "&DATEDIF(B1, C1, "d")&"d" = 1m 31d

[kathleenbabb]

Once again, your knowledge of MS Office suite is helpful. Thank you for sharing.

[acacia_w]

My new favorite channel! Thank you. I've learned a few things from you in one morning that are really going to help me in my work. 🙏👏

[Tsitsi]

Thank you so much for the clear instructions, well appreciated.

[ramengogoi]

Thanks a lot brother I was watching videos people using datedif but i couldn't find it in my excel now I now the secret, thanks a lot brother

[gopalakrishnan]

This Part is 👌 🌲 இந்த பகுதி மிகவும் அருமை. It is more useful for all the Pupil & People

[orlahastings]

Super useful as always. Thank you for sharing.

[saramedina]

Thank you very much!!! I do a monthly report at work and this video will cut my time off when using this formula.

[JCEurovisionFan]

I hope you upload more videos on Wednesdays and Fridays

[shoppersdream]

Nice, thanks! I was just going away when DateDif was not showing up without entering the ( How would you do if One date is showing Date with Time and another is showing just Date and Some records are showing only Begin Date but End Date is empty. How would you solve this scenario? Thanks

[juliusjaypepito]

This is really great sir. But can you also show the formula for date of expiry notification? Let's say notification 7 days before date of expiry. is it possible in excel? ty

[davideastham]

Will this also work if the dates I have in the spreadsheet have the time zone listed or does it have to be removed first? I have a spreadsheet where I'm trying to calculate between a start time and submission time and the date that includes the time zone.

[manoranjansaikia]

Datedif formula is not working in my 2016 professional Plus ms Excel why?

[Dragon_]

if you click the function help after typing the first parenthesis then it tells you this in the help screen

Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results under certain scenarios. Please see the known issues section of this article for further details.

[abhishekgoyal]

Sir this is a great video... But i am facing a problem in this formula... One my customer is with me from 42 months but in years it's showing 3 years instead of 3.5 years

[aisyakamila]

My problem is, there are some blanks in between. Any solution?

[salahmed]

what to do if it did give me "value " ?

[fadakay]

I get an error after entering the first date,

[hamood]

Formula can be found in excel sheet. But no one tells how to enter date in date column. 11/3/24 does not work and neither 11-MAR-2024 and neither 2024/03/11. Formula returns error. Missed the most critical info in the video.