Forum Discussion
frontdesksm
Jul 31, 2019Copper Contributor
Understanding Datedif regarding days
Look at column C. The days are all 30 days. Why are they all the same? I agree with year and month but I can not figure out days. Another example is Today is July 31, 2019 substract from May 4, ...
- Jul 31, 2019
Hi
I created a video tutorial about the DateDiff Function in Excel
You can watch it here
https://www.youtube.com/watch?v=9c3DgoTzTU8
Hope that Helps
Nabil Mourad
nabilmourad
Jul 31, 2019MVP
The DateDif function does not show a tool tip it's an old function that Microsoft kept for backward compatibility, although it works just fine.
So you can either copy and paste the function provided by the Excel Guru SergeiBaklan
or
Learn about the function in details from my tutorial in the previous reply
Thanks
Nabil Mourad