Working with payroll dates

Conditional Formatting in Google Sheets

Adam Steinfurth

Instructor

Employee pay detail

Date Regular Hours Regular Rate Total
6/8/2025 0.00 $15.25 $0.00
6/9/2025 8.00 $15.25 $122.00
6/10/2025 7.50 $15.25 $114.38
6/10/2025 8.00 $15.25 $122.00
6/11/2025 6.00 $15.25 $91.50
6/ 12/2025 5.00 $15.25 $76.25
6/13/2025 5.00 $15.25 $76.25
6/14/2025 8.00 $15.25 $122.00
6/15/2025 0.00 $15.25 $0.00
Conditional Formatting in Google Sheets

ISDATE Function

=ISDATE(value)

  • Checks to see if a value is a valid date

What breaks dates?

  • Spaces
  • Text
  • Non-existent dates (March 32nd)
Conditional Formatting in Google Sheets

Checking for valid dates

=ISDATE(A2) Custom Formula ISDATE

Conditional Formatting in Google Sheets

Menu option

=ISDATE(value)

  • Checks to see if a value is a valid date

What breaks dates?

  • Misspellings

  • Text

  • Non-existent dates (March 32nd)

Conditional Formatting in Google Sheets

Remove the rule

Delete the rule

Conditional Formatting in Google Sheets

Duplicate Check

Conditional Formatting in Google Sheets

Date range

Is between

Conditional Formatting in Google Sheets

Ready to go!

Conditional Formatting in Google Sheets

Preparing Video For Download...