Hello,

I am trying to write a formula to pull in the # of days that fall within a quarter- that are in a larger range. In other words, I have contracts that span over years with different start and end dates and I would like to return how many days they fall within Q1.

Cell B2 start date 1/1/2016 Cell C2 end date 3/31/2016

Cell B4 Effective Date
Cell C4 Expiration Date

I am trying to use a countif but having trouble. I am trying to return the dates in Q1 2016 in column D

Capture.PNG