Forum Discussion
How do I find number of months between dates in every quarter?
I have Start Date and End Date columns. I need to count how many months fall within Quarter4 2021 and Quarter1 2022, so I can count profit per quartal. Revenue is based on a month service. Client...
In H2:
=IFERROR(DATEDIF(MAX(C2,DATE(2021,10,1)),MIN(D2,DATE(2021,12,31)),"m")+1,0)
In I2
=IFERROR(DATEDIF(MAX(C2,DATE(2022,1,1)),MIN(D2,DATE(2022,3,31)),"m")+1,0)
Fill down.