I am trying to compare 2 date columns with an odd result

I am trying to count the number of submissions on a daily basis with =COUNTIF({Loans Range 1}, =[Begin Date]@row).

Most of the formulas return the correct number of submissions.

What it looks like it is doing is applying the submissions entered after a certain time (5 PM?) to the next day.

Dependencies are disabled

Resources management is disabled

Is there anything I can do to have it read the date only and not the time?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!