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

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. 🙏👏

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

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

Super useful as always. Thank you for sharing.

Nice tutorial, thanks for sharing

Very helpful, thanks very much!

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

Thanks brother it works so well

Thanks for the share.

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

This helps thank you

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

Help full

Thank you

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.

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

I hope you upload more videos on Wednesdays and Fridays

Thanks

That's DIF is fab ☘🌂☘🏄‍♂️

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

@shivrajkumar4155

3 ай бұрын

It's only for versions earlier than 2016

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

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

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

I get an error after entering the first date,

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.

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

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.

@kulinterests

Ай бұрын

m/d/y

@hotpotato7392

21 сағат бұрын

All the date formats you mentioned are valid. If you are entering them directly into the formula, then they must be within quotation marks, e.g. _=DATEDIF("2024/03/11","2024/07/09","d")_

Not working 😢