Google Sheets - Add a Pop-Up Calendar Date Picker

[@AleCanepaOK]

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

[@ProlificOaktree]

Glad it helped out!

[@Lorgayle1]

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

[@ProlificOaktree]

Glad it helped!

[@FlamingGeekFrosty]

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

[@RR_Bryan.University]

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

[@ProlificOaktree]

You're welcome!

[@flavi100]

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

[@rickcbertino5656]

simple - worked - thank you!

[@ProlificOaktree]

Glad it helped!

[@ondnimshamotivation]

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

[@ProlificOaktree]

Thank you so much 🙂

[@Random_-Ramblings]

Clear, simple and well explained! Thanks a lot.

[@ProlificOaktree]

You're welcome!

[@anjuYT-ui4hv]

Thanks this will help a lot with my new work

[@ProlificOaktree]

Great to hear!

[@GenaOliver]

Clear and concise! Thank you!

[@ProlificOaktree]

Glad it was helpful!

[@biancalandis]

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!!

[@ProlificOaktree]

You're welcome!

[@ServantStatusMinistries]

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

[@ProlificOaktree]

Glad it helped you out!

[@mailnupurbhandari]

such clear and easy to follow instructions .

[@ProlificOaktree]

Glad it was helpful!

[@akshaygole7195]

On point. No time waste. Thanks

[@longnguyenkim7336]

very useful tips and clear direction, thank you

[@ProlificOaktree]

Glad it was helpful!

[@Yiannis_Lucacos]

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?

[@ProlificOaktree]

You’re outta luck

[@shiro4u1]

Concise. Clear. Understood.

[@ProlificOaktree]

Just what I hoped. Thank you!

[@pol-attractmode]

so useful, thank you!

[@ProlificOaktree]

Glad it was helpful!

[@DrAbduA.Yesufe]

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

[@HeatherRogersMagic]

Thank you! This was so validating!

[@erikjohannes]

Thx! Very helpful and to the point video.

[@ProlificOaktree]

Anytime!

[@Readerpaige1]

Thank you this was very helpful!

[@ProlificOaktree]

I'm so glad!

[@risacates5624]

Thank you! This was exactly what I needed!

[@ProlificOaktree]

Glad it helped

[@monkmodementor]

Very useful! Thank you!

[@ProlificOaktree]

Glad it was helpful!

[@kitturamu]

Thank you so much, it helped me a lot.

[@ProlificOaktree]

Glad to hear that!

[@bec8922]

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?

[@ProlificOaktree]

Sounds like you have Data validation applied to the cell. How about just removing the Data validation or changing the settings on it.

[@bec8922]

@@ProlificOaktree thanks for the reply. It was pre-made for me to use so it has a bunch of background code and I’m so new if I delete things I could break the whole sheet. I’ll just put up with the red marks if I can’t find the answer lol thank you though.

[@codingdragons]

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.

[@ProlificOaktree]

Not that I know of

[@codingdragons]

@@ProlificOaktree thank you!

[@silvestrecamposano6317]

Thank you again, Sir!...

[@christinataylor7382]

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

[@ProlificOaktree]

I think it was this video. kzbin.info/www/bejne/oZPdoKFjgq6oq7Mfeature=shared

[@user-uf6el6hd9h]

Super helpful!

[@Sisa-fm8dm]

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

[@sumanthiyengar9641]

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

[@ProlificOaktree]

Whoa dude.

[@lluviag.5041]

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?

[@ProlificOaktree]

Right-click and choose insert note. You couldn't do it in the cell because then it wouldn't be a date field.

[@joanmiquelferrer2124]

I wonder if it is possible to select a date with the keyboard from the calendar pop-up. Thanks!

[@ProlificOaktree]

I don't think so.

[@user-vq8ws6go8g]

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?

[@ProlificOaktree]

Look into the settings and change your Locale

[@wolfi2027]

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

[@ProlificOaktree]

No, I wish.

[@Davidahernchannel]

Perfect many thanks!

[@ProlificOaktree]

👏🏽

[@user-tw2td4cm3d]

This was helpful, thankss

[@brianjaffe8747]

Nice job, you got my sub

[@ProlificOaktree]

Awesome, thanks!

[@RedEyedJEdi410]

Thank you for this!

[@ProlificOaktree]

My pleasure!

[@Skelym]

Thank you sir!

[@ProlificOaktree]

Excellent!

[@shaziazshaikh1177]

Thank you, This helped!

[@ProlificOaktree]

Glad it helped!

[@juju537]

Thank you!!

[@ProlificOaktree]

You're welcome!

[@Dot02]

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

[@ProlificOaktree]

Unfortunately no

[@markbriggs5969]

Thanks!

[@ProlificOaktree]

Welcome!

[@tirthyatra5528]

Thank you so much! 🙏

[@ProlificOaktree]

You're so welcome!

[@TheKirstebee]

thanks so much!

[@ProlificOaktree]

You're welcome!

[@ValueEnvision-Andreya]

Thank you so much

[@ProlificOaktree]

You're most welcome

[@zerokhan858]

thank you so so so much!!!!!

[@ProlificOaktree]

Anytime!

[@iggymach]

nailed it. Thanks man

[@ProlificOaktree]

You bet!

[@victoriasvibesss]

thank you

[@ProlificOaktree]

You’re welcome!

[@lylestavast7652]

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 ...

[@ProlificOaktree]

This may help. Google Sheets - Show the Day of the Week as Text kzbin.info/www/bejne/aZqXg5p5j9CLoqM

[@33ZackG]

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!

[@ProlificOaktree]

You can't change the default behavior.

[@joanmiquelferrer2124]

With the second method, just pressing the intro key lets the calendar pop-up open.

[@swarupmazumder]

Thank you 😃

[@ProlificOaktree]

No problem!

[@schweizerjoenzsevero4646]

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?

[@olivianavarro9146]

I need this too! How do we select a different year without having to scroll through all the months?

[@adayinlife101]

Thanks

[@ProlificOaktree]

Welcome

[@pinnang5082]

thanks!

[@ProlificOaktree]

Welcome!

[@electricloco-yt9ze]

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

[@ProlificOaktree]

Do it with number formatting from the menu.

[@sparkleegrl]

Does this exist in the exact way for Excel?

[@ProlificOaktree]

Nope!

[@ikkie2725]

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

[@ProlificOaktree]

Format, Number, Custom date and time

[@poojanavi5101]

that was greate

[@ProlificOaktree]

Thanks!

[@taifurislam3997]

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

[@ProlificOaktree]

Excel is for boomers!

[@اطفال2024]

how to double click at google sheet with mobile app

[@ProlificOaktree]

You can't get the pop-up calendar on mobile.

[@muhammadridzuanbinnordinkp6964]

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

[@ProlificOaktree]

It doesn't do it on mobile. Probably not the answer you wanted.

[@SolangeWaithe]

I believe it works on the android mobile app but not the iOS app

[@alohathailand7477]

nice

[@ProlificOaktree]

So nice

[@nk_BioBuG]

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

[@ProlificOaktree]

Check your spreadsheet location settings or just change the number format.

[@creepyed]

Super helpful, thank you!

[@ProlificOaktree]

You're welcome!

[@rickcbertino5656]

Thanks!

[@ProlificOaktree]

You rock! Thank you.