Thank you so much! Clear, concise, and straight to the point!

It works like a charm! (I preferred the second option) Great explanation, straight to the point! Thanks!!!

Thanks so much!! Clear instructions, easy to understand, and it works! I came here for the 2nd option, and you didn't disappoint .

Thanks very much. Clear instructions. Just what I needed to know!!

On point. No time waste. Thanks

Clear and concise! Thank you!

Thank you! This was so validating!

Soy de chile, ningún video en español me ayudó, sólo el tuyo, Te agradezco!! 😀

Clear, simple and well explained! Thanks a lot.

Thank you so much this was so helpful and straight to the point!!!

Super helpful!

So much useful and simple you have shown it👏👏👍

Thank you! This was exactly what I needed!

Thank you again, Sir!...

This was great to see an updated version thank you for taking the time to do this. Any ideas on how to remove the red mark and pop up that says must be a valid date when the space is left blank for users?

simple - worked - thank you!

Thx! Very helpful and to the point video.

so useful, thank you!

such clear and easy to follow instructions .

This is super helpful! Is it possible to add text that instructs people to double click in the date field to make the calendar pop-up?

Thank you for the informative short video Can you please tell me and how we add time like we did the dates? Plus, despite marking reject input if the date is invalid in the advanced options, the spread sheet still accepts wrong dates. Wrong date means ...the date that is not similar to the data entry date, as I understand. If so, how can we limit entry of back or future dates, and allow only the date similar to data entry date

Very nice, thank you for sharing. How about if you need it to work just by one click so no typing input will be allowed?

Thank you, This helped!

ssoooo helpful! thank you so much sir for this video 🙏

Concise. Clear. Understood.

very useful tips and clear direction, thank you

Very useful! Thank you!

This was helpful, thankss

Thank you this was very helpful!

Hi there, quick question. Is it possible to add time. So we can know the exact date and time. Thanks @Prolific Oaktree. 👍🏽

Thanks this will help a lot with my new work

Thank you so much, it helped me a lot.

i want change th format of date like dd/mm/year

Perfect many thanks!

OMG, thank you for this. I was receiving an error on a sheet that was given to me and I just needed to change the validation rules. Thank you!!

Thank you so much! 🙏

Thank you this is most helpful. Is there any way that we can change the date format to be 06 /09 meaning 06 September instead of 09/06?

Thank you!!

Thank you for this!

OK - how do you leave it so the user can hit the cell, see a calendar - make a date choice and have one of the fields of that date be all that's shown - like the 21st or the year of that date ? Basically nest the @date so that it's return then gets stripped down to just the day the way the =day would do with a valid date ...

Thank you sir!

thank you so so so much!!!!!

nailed it. Thanks man

Hi! This was very helpful. You mentioned a video on date DIV for passage of dates, but I can't find the video

Thanks!

Perfect thank you. Does there also exist a way to add a Pop-Up Timer Wheel?

Awesome lesson! Thank you! Is there a way to make a time as well? For instance two columns, one has Start time and the other has End or something like that.

Nice job, you got my sub

Thank you 😃

thank you

Anyway to have the calendar pop up on just one click? I would prefer people se its there without having to double click into the cell. Thanks!

Thanks

thanks!

I can't select YEAR. I was trying to make it like selecting the specific Year, Month, and day. But the only option is to click the arrow button for each month. I want it to have a selectable Year as well. How do I do that?

How do I change the formatting to day-month-year instead of moth-day-year?

How to do that 2nd option in excel 2021? I can do in 2019 but can't in 2021

that was greate

Does this exist in the exact way for Excel?

how to double click at google sheet with mobile app

I was in shock when you told Feb 13th 2023 only difference is that I'm watching it in 2024, same date🥶

When using mobile, this doesn't work on iPhones as no Calendar pops up when double clicked. Please help...

nice

How to convert pop out date in mm/dd/yyyy in google sheets 2024

Super helpful, thank you!

Thanks!