Getting difference between dates from 2 date ranges then categorize it in another table

Hello


I need help with this issue. Basically, what I need is to get the difference between 2 date range. Then check if it exceeds a certain # of days.
I know how to do this separately. But I need help in combining them.

example:
if (MONTH(ASD) = "January") then
if (CLOSED <> "") then
X = Closed - ASD;

Please refer to my attached file.

to get the Month from the date range, I used this formula:
=SUMPRODUCT((MONTH(C:C)=1)*1)

For the Difference in Dates, I use
=IF(B<>"",DAYS(B,C),0)

Any help is appreciated. Thanks.

which column do you the X value.
where is the max limit of # days.