Excel DATEDIF function to get difference between two dates - Ablebits
https://www.ablebits.com/office-addins-blog/excel-datedif-calculate-date-difference/
webMay 3, 2023 · If i want to calculate the YY-MM-DD between two dates, i am getting the difference without inclusion of last day. Example: Employment Tenure of Mr. XYZ is From 01-12-2020 to 01-06-2023. I am applying following formula in Excel: =DATEDIF(D2,E2,"Y") & " Years, " & DATEDIF(D2,E2,"YM") & " Months, " & DATEDIF(D2,E2,"MD") & " Days"
DA: 41 PA: 31 MOZ Rank: 21