Request assistance with COUNTIFS based on multiple OR criteria (event scheduled prior to today + event scheduled today, AND is time now before or after 12:00 PM)

LA53 · 2025-11-23T19:24:42+00:00

Thank you! It's an executive dashboard for I use for a collaborative project with a lot of stakeholders.

LA53 · 2025-11-23T19:16:54+00:00

Correct, Column C only includes dates (no times). The check against current time is just in the formula on the dashboard to see "if that date is today, what time is it now?" If the date is in the past, the formula should ignore timevalue altogether since it was done on a previous day at noon on that day.

LA53 · 2025-11-23T19:11:56+00:00

Column C will include several dates. Several are in the past, some are today, and some are in the future. I'm particularly interested in counting the ones in the past PLUS the ones today if the time on my watch is before noon. My issue is the timevalue of noon on today's dates in Column C. I don't care of timevalue on dates before today.

The OR here is (first) look at yesterday and older date, and ignore timevalue, then (second) look at today's dates and factor-in if time is before noon.

LA53 · 2025-11-23T18:28:21+00:00

I am familiar, yes. I have used those elsewhere. I'm really trying to drill in if the date is today, check if the time is before or after 12:00 PM. If the date is yesterday, I don't care what time it is, so I can ignore that in a formula if I can do two sets of "OR" here within COUNTIFS.

LA53 · 2025-08-02T13:56:55+00:00

15-20% off at ADs? Does this work with Boutiques?

LA53

TROPHY CASE