I currently have the follow formula inside of a dropdown:
=IF(HasDate="YES",INDIRECT("'DROPDOWN LISTS'!$H$4:$H$"&COUNTA('DROPDOWN LISTS'!$H$4:$H$40)+3),COUNTA('DROPDOWN LISTS'!$H$4:$H$40)+4)
If the user selects Yes to the HasDate dropdown, a list of dates is shown on a seperate dropdown and if they select no I show a blank dropdown with no selection available. This seems to work fine, the only problem is when The user selects Yes and choices a Date but later on changes HasDate to No, whilst the blankdown is correctly switched to, the previously selected date is still shown.
Is there a simple way to clear the date from selection under this circumstance.
Many thanks.
Bookmarks