Date Formula with Threshold

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))

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.