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 | Account | Start date | End date | Periods | Sum | Currency | Q4 2021 | Q1 2022 |
| Acer | 562 | 01.12.2021 | 31.12.2021 | 1 | 26 000,00 | USD | ||
| Accor | 565 | 01.01.2022 | 31.07.2022 | 7 | 3 150,00 | USD | ||
| Adidas | 574 | 01.01.2021 | 31.12.2021 | 12 | 11 167,20 | USD | ||
| Activision Blizzard | 577 | 01.01.2022 | 31.12.2024 | 36 | 108 000,00 | USD | ||
| Aflac | 707 | 01.02.2021 | 31.01.2022 | 12 | 3 500,00 | USD | ||
| Adobe | 710 | 01.02.2022 | 31.01.2023 | 12 | 3 500,00 | USD | ||
| Agilent Technologies | 924 | 01.11.2021 | 31.01.2022 | 3 | 1 050,00 | USD | ||
| Air France-KLM | 1190 | 01.12.2021 | 31.12.2021 | 1 | 73 500,00 | USD | ||
| Alibaba Group | 1265 | 12.07.2021 | 11.11.2024 | 40 | 37 800,00 | USD |
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.
