• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dependent dropdown validation with date

Y

ysherriff

Member
I have the following formula:

=OFFSET(DATE_START_CELL,MATCH(MONTH,CONTROL_MONTH,0),0,COUNTIF(CONTROL_MONTH,MONTH),1)

This formula is inputted in the data validation and returns the days of the month based on the selected month. For some reason, when I select a particular day from the drop down list, it returns the date in a text format.

So I tried to modifyt the formula as such:

=TEXT(OFFSET(DATE_START_CELL,MATCH(MONTH,CONTROL_MONTH,0),0,COUNTIF(CONTROL_MONTH,MONTH),1),"mm/dd/yyyy")

and it doesn't work.

Can anyone help me with the appropriate way to do a dropdown validation based on date selection?

I have attached the file with the formula as an example.

Thank you.
 

Attachments

your original formula was correct. The ouput from the dropdown is not text, but rather than date in General format (as dates are stored as integers in XL). Select the cell with the dropdown, and change the format to Date, and you should be good.

If that doesn't help, could you point to the specific worksheet/formula/cell in your example you want us to look at?
 
You must log in or register to reply here.
Back
Top