Google Sheets - Add a Pop-Up Calendar Date Picker
HTML-код
- Опубликовано: 17 июл 2024
- Learn how to insert a pop-up date picker into Google Sheets. We'll cover two methods. Choose which one works best for you.
Calculate the passage of Time Mentioned in Video - • Google Sheets - Calcul...
Calculate the passage of Time for Shorter Durations - bit.ly/timedif
Learn more about Google Sheets - • Google Sheets - Full T...
#googlesheets #spreadsheet 
Наука
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!!!
Glad it helped out!
Thanks so much!! Clear instructions, easy to understand, and it works! I came here for the 2nd option, and you didn't disappoint .
Glad it helped!
Thanks very much. Clear instructions. Just what I needed to know!!
You're welcome!
On point. No time waste.
Thanks
Clear and concise! Thank you!
Glad it was helpful!
Thank you! This was so validating!
Super helpful!
Clear, simple and well explained! Thanks a lot.
You're welcome!
Thank you! This was exactly what I needed!
Glad it helped
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?
Sounds like you have Data validation applied to the cell. How about just removing the Data validation or changing the settings on it.
@@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.
So much useful and simple you have shown it👏👏👍
Thank you so much 🙂
Thank you so much this was so helpful and straight to the point!!!
Glad it helped you out!
simple - worked - thank you!
Glad it helped!
so useful, thank you!
Glad it was helpful!
Soy de chile, ningún video en español me ayudó, sólo el tuyo, Te agradezco!! 😀
Thx! Very helpful and to the point video.
Anytime!
such clear and easy to follow instructions .
Glad it was helpful!
Thank you, This helped!
Glad it helped!
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!!
You're welcome!
Concise. Clear. Understood.
Just what I hoped. Thank you!
Thanks this will help a lot with my new work
Great to hear!
very useful tips and clear direction, thank you
Glad it was helpful!
Very useful! Thank you!
Glad it was helpful!
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?
Right-click and choose insert note. You couldn't do it in the cell because then it wouldn't be a date field.
This was helpful, thankss
Thank you!!
You're welcome!
Perfect many thanks!
👏🏽
Thank you this was very helpful!
I'm so glad!
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?
You’re outta luck
ssoooo helpful! thank you so much sir for this video 🙏
Thank you so much, it helped me a lot.
Glad to hear that!
Thank you so much! 🙏
You're so welcome!
Thank you sir!
Excellent!
Thank you for this!
My pleasure!
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
thank you so so so much!!!!!
Anytime!
Thanks!
Welcome!
nailed it. Thanks man
You bet!
thank you
You’re welcome!
Thank you 😃
No problem!
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.
Not that I know of
@@ProlificOaktree thank you!
Hi! This was very helpful. You mentioned a video on date DIV for passage of dates, but I can't find the video
I think it was this video. ruclips.net/video/kbzon-MIuuQ/видео.htmlfeature=shared
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?
Look into the settings and change your Locale
Nice job, you got my sub
Awesome, thanks!
Hi there, quick question. Is it possible to add time. So we can know the exact date and time. Thanks @Prolific Oaktree. 👍🏽
Unfortunately no
thanks!
Welcome!
Perfect thank you. Does there also exist a way to add a Pop-Up Timer Wheel?
No, I wish.
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 ...
This may help. Google Sheets - Show the Day of the Week as Text
ruclips.net/video/3i4RgCZkXlA/видео.html
i want change th format of date like dd/mm/year
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!
You can't change the default behavior.
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?
I need this too! How do we select a different year without having to scroll through all the months?
that was greate
Thanks!
How to do that 2nd option in excel 2021? I can do in 2019 but can't in 2021
Excel is for boomers!
I was in shock when you told Feb 13th 2023 only difference is that I'm watching it in 2024, same date🥶
Whoa dude.
Does this exist in the exact way for Excel?
Nope!
How do I change the formatting to day-month-year instead of moth-day-year?
Format, Number, Custom date and time
how to double click at google sheet with mobile app
You can't get the pop-up calendar on mobile.
nice
So nice
When using mobile, this doesn't work on iPhones as no Calendar pops up when double clicked. Please help...
It doesn't do it on mobile. Probably not the answer you wanted.
I believe it works on the android mobile app but not the iOS app
How to convert pop out date in mm/dd/yyyy in google sheets 2024
Super helpful, thank you!
You're welcome!
Thanks!
You rock! Thank you.