Count if days between dates in two ranges are less than or equal to 30 days

**ll311** · 01-03-2019, 04:00 PM

Hi All, huge fan of the Excel Forum site here for years in helping me use some fancy formula tricks via the threads of others.

Was wondering if someone has came across creating a formula that calculates the days in dates within two ranges and counting them without the use of a helper column?
Normally, I would create a helper column and do a countifs() but figured if would be cleaner if there was a way to nest a days calculation inside a countif() and read off of that.

I attached a sample .xlsx file for reference.

Any help and insight greatly appreciated!

Thanks,
Linda

**Root_** · 01-03-2019, 05:32 PM

Is this what you need?

=SUMPRODUCT(--(C2:C10-B2:B10<=30))

**Sam Capricci** · 01-03-2019, 05:36 PM

could you provide a little more detail? You have a date in col B and a date in col C, where would you want to put the difference between both dates if not in another column somewhere?
And is there a difference between the number you have in col D and what you would expect it to be - you have 4/23/17 in B2 and 12/3/18 in C2 and 589 days in D2 as the difference, do you expect a different result?

Root gave you an answer while I was still typing, maybe that is what you are looking for?

Count if days between dates in two ranges are less than or equal to 30 days

LinkBack

Thread Tools

Rate This Thread

Display

Count if days between dates in two ranges are less than or equal to 30 days

Re: Count if days between dates in two ranges are less than or equal to 30 days

Re: Count if days between dates in two ranges are less than or equal to 30 days

Thread Information

Users Browsing this Thread

Similar Threads

Formula that counts dates that are between 60 days and 30 days before todays date

Calculating Market Days (excluding weekends, holidays) & short days between two dates/time

How to Group raw data using date ranges: less than 5 days, between 5 and 14 days and older

Formula needed to calculate number of days between 2 dates that equal a given value

Working days and holidays between dates/ranges

Help on count the number of days in between dates and then average number of days

Remove Dates less than or equal to 30 days from Today’s Date

Bookmarks

Bookmarks

Posting Permissions