Forum Discussion
DATEDIF's known issue in "md" unit
Hi folks, On this link: https://support.office.com/en-us/article/DATEDIF-function-25dba1a4-2812-480b-84dd-8b32a451b35c You will find at the bottom of the webpage a workaround for the DATEDIF's ...
Hi
I think I managed to complete the "workaround" with this formula:
=IF(DAY(EndDate)<DAY(StartDate);EndDate-DATE(YEAR(EndDate);MONTH(EndDate)-1;DAY(StartDate));EndDate-DATE(YEAR(EndDate);MONTH(EndDate);1)-DAY(StartDate)+1)