Forum Discussion
DATEIF 30th v 31st of Month calculating months
Hi I am trying to calculate number of months between two dates. All works well using =DATEDIF(O4,P4,"m") eg 31/07/2019 to 31/08/2020 Returns 13 months However 31/07/2019 to 31/06/2020 Return...
Hi
For solving the month end date problem I use a simple if statement IF(DAY(E7)<DAY(C7),then make the next statements.
It is tricky that datedif can be tricky for month end.
Hope this helps
Kind regards
Paul