Forum Discussion
Problem with DATEDIF function
Hi. I'm trying to calculate the difference between two dates in Excel. I have used the DATEDIF function to do this in the past, but it doesn't seem to be working correctly this time. Instead of re...
Riny_van_Eekelen Would =DATEDIF formula be the right formula to use if I need to calculate the age of my students in Years and Months on September1st? because I seem to have work on one excel file and not the other despite formatting the date cells as cells and the result cells as general or text. I was thinking maybe one excel file is older than the other but still I count make it work.
Please help!
Dalal1310 Not sure where to look. If DATEDIF works for you, go for it. Just be aware that is might not always be accurate.
https://support.microsoft.com/en-us/office/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c