CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Vikas Rinvi
Vikas Rinvi

Reputation: 1288

How to make dropdown in the Google sheet for day, month and year in separate column

I have tried the list of items approach but stuck in the year.enter image description here

Upvotes: 1

Views: 5992

Answers (1)

delimiter
delimiter

Reputation: 795

If you just want to select a valid date, you need to set your Criteria to "Date", not to a list of items.

See the screenshot below: date validation Otherwise there is no clean way of adding the date validation. You can of course choose month, day and year separately from a dropdown, but not very clear why you'd want it that way as then you will need to concat those entries in a new cell.

Upvotes: 1

Related Questions