Date Formula with Threshold

Nicole Hodges

I am trying to count the number of rows that have a date within the following thresholds:

• Date falls within the next 10 days
• Date falls within the next 15 days
• Past due date

I tried the following but realized I don't actually want it to count less than 10 days from TODAY BUT the date in the "Lease Move in Log Range 3."

How would I use that date versus today?

=COUNTIFS({Lease Move in Log Range 2}, Name@row, {Lease Move in Log Range 1}, "", {Lease Move in Log Range 3}, <=TODAY(10))

Paul Newcome

Are you trying to set up three separate COUNTIFS? Are you able to provide some screenshots?

Nicole Hodges

Yes! Pulling from a different sheet into my data sheet.

Would like the following criteria:

• Data Range 2, Name
• IF data range 1 is BLANK (meaning there is no date in that cell)
• Pull from data range 3 (count) if that date is in the next 10 days