How many days in a month are within a certain date range?

[OldManExcellor]

I have a month, let's say:
April 2014

I have a date range, let's say:
2014-04-20 - 2015-05-13

How can I calculate the number of days in that date range that are also in the specified month?

[TMS]

Which cells are all those dates in?

Suggest you post a sample workbook.

Regards, TMS

[newdoverman]

I take it that you mean the number of days within the range of dates specified.

If the start date is in A1 and the end date is in B1, in C1 enter:

Please Login or Register  to view this content.

In D1 enter:

Please Login or Register  to view this content.

If there are more than 2 consecutive months involved then this becomes more complicated.

[AlKey]

Please see attached file.

In C2 format cell as Custom "mmm-yyy"

=IF(ROWS($C$2:C2)>DATEDIF($A$2,$B$2,"M")+2,"",IF(EOMONTH($A$2,ROWS($A$2:A2)-1)>$B$2,$B$2,EOMONTH($A$2,ROWS($A$2:A2)-1)))

In D2

=IF(C2="","",DATEDIF($A$2,$B$2,"d")-DATEDIF(C2,$C$15,"D")-SUM($D$1:D1))

Format cell as General

[AlKey]

Thank you for the feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).