0

Compare 2 date ranges

Hi,

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
etc etc

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?

Thanks,
Jef

9 comments

Please sign in to leave a comment.