How to automate date validation using VBA in Excel. More details available at https://www.exceltrainingvideos.com/automate-date-validation-using-vba/
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.