Have you tried a data validation formula?

I'm assuming 'today's' date is a hard coded date in a cell and you want to test the system date today against it. If not upload your workbook and give us a few examples of what entries are permitted and when.