Compare today with column of dates return true / false in excel?

I want to compare today's date with other sheet's column [which contains a list of date's] and in return, if today's date is not available in the list it should say no/false or show red in color.

For example: I have an excel sheet with multiple sheets on it. On the summary sheet, I want to know the status of other sheets like whether the other sheets getting updated on time or not.