Is there a formula to count how many times todays date is entered into a sheet?

Webby

Paul Newcome

There's the problem. The LEFT function outputs a text string that only looks like the date. Try the DATEONLY function instead and change the column type to a date type column.

Paul Newcome

How is your "Date only" column currently being populated?

Webby

=LEFT([Date & Time Sign in]@row, 8)

Paul Newcome

There's the problem. The LEFT function outputs a text string that only looks like the date. Try the DATEONLY function instead and change the column type to a date type column.

Webby

Thanks Paul this seems to have worked.

Now my issue is that the date created and auto Date Only don't match.

Webby

All good I've gone with a workaround using Record Date Automation.