I have a spreadsheet to collate the time off requests for my staff for their roster. In one cell they need to select 'Date of Request'. I have a drop down list that only allows them to select today's date as defined by a reference cell with =TODAY().
Looking around some forums though, it would look like when I check this tomorrow, the date will have updated.
I want to limit the cell value so that it has to be today's date (so they can't change dates or enter an earlier date to make it look like they were in first) with a static value...
Any help is greatly appreciated!