Formula Counting Created Date as Following Day When Recorded After 5:30 PM PDT
When creating a metric sheet that evaluates entries in another sheet, I am attempting to write a COUNTIF formula that counts all entries for that day, but any entries recorded after 5:30 PM PDT are counted towards the following day. I created a helper column that converts the system column into just a date, and that fixes the issue. I am curious if anyone knows the reason why this happens? Tried searching for the issue, but was unable to diagnose on my own.
Help Article Resources
Check out the Formula Handbook template!