I have a datefilter: 06/01/2013..15/02/2013
Then I have colums for each month:
Column A: 01/01/2013..31/01/2013
Column B: 01/02/2013..28/02/2013
Now I want to know how many days there are in the datefilter for column A (this should be 25) and how many in column B (this should be 15)
I need to calculate how many days for each month that are in the filter…
Does anyone have an idea?
Compare 2 date ranges