Forum Discussion
Solved
Help Needed - How can you count number of days that falls on a specific month based on range of date
Hello, Good day. I hope everyone is doing well during this time. I need help if someone can show or suggest how I can count the number of days that falls on a specific month based on a range ...
ian_122282 Played around with your examples and came up with a perhaps not very elegant, but working solution. Note, I used a helper column D. It also allocates total duration to more than two months, if applicable. See attached.
ian_122282 Played around with your examples and came up with a perhaps not very elegant, but working solution. Note, I used a helper column D. It also allocates total duration to more than two months, if applicable. See attached.
Riny_van_Eekelen thanks for providing a working solution.
This gives me now some idea of how this work and I'll try to make some improvements.
