Formula to determine if created (Date) column matches a date column or is today
I have a form my team uses to record several instrument calibrations, with an auto generated created date for each entry. Is there a way to compare the created date to a date column in another sheet to see if the 2 columns match? Or maybe determine if the date in the created date column is today? I think the format of the created date column is not allowing any of the formulas I have tried to work.
The instruments are supposed to be calibrated every week day, and I am trying to figure out a way to generate an alert if a day gets missed.
Right now I have a report that pulls all the calibrations completed, filtered for today, that I then manually compare to another sheet where I generated all the weekday dates, to check off that each instrument was calibrated every day.
Help Article Resources
Check out the Formula Handbook template!