Forum Discussion
Treklogg
Jun 25, 2022Copper Contributor
Count days in any given month between two dates
I am trying to make a list that tells me how many of the days within a periode is in a given month.
Attached picture illustrates how i want the output (column D).
Any good ideas?
2 Replies
Sort By
- OliverScheurichGold Contributor
=IFERROR(DATEDIF(MAX(DATE(2022,5,1),B2),MIN(DATE(2022,5,31),C2),"d")+1,0)
Maybe with this formula.