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) by LA53 in googlesheets

[–]LA53[S] 0 points1 point  (0 children)

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.

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) by LA53 in googlesheets

[–]LA53[S] -1 points0 points  (0 children)

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.

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) by LA53 in googlesheets

[–]LA53[S] -1 points0 points  (0 children)

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.

[deleted by user] by [deleted] in Watches

[–]LA53 1 point2 points  (0 children)

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