It works like a charm! (I preferred the second option) Great explanation, straight to the point! Thanks!!!
@ProlificOaktree Жыл бұрын
Glad it helped out!
@Lorgayle12 ай бұрын
Thanks so much!! Clear instructions, easy to understand, and it works! I came here for the 2nd option, and you didn't disappoint .
@ProlificOaktree2 ай бұрын
Glad it helped!
@FlamingGeekFrosty6 ай бұрын
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!
@flavi1002 ай бұрын
Soy de chile, ningún video en español me ayudó, sólo el tuyo, Te agradezco!! 😀
@rickcbertino56567 ай бұрын
simple - worked - thank you!
@ProlificOaktree7 ай бұрын
Glad it helped!
@ondnimshamotivation11 ай бұрын
So much useful and simple you have shown it👏👏👍
@ProlificOaktree11 ай бұрын
Thank you so much 🙂
@Random_-Ramblings6 ай бұрын
Clear, simple and well explained! Thanks a lot.
@ProlificOaktree6 ай бұрын
You're welcome!
@anjuYT-ui4hv11 ай бұрын
Thanks this will help a lot with my new work
@ProlificOaktree11 ай бұрын
Great to hear!
@GenaOliver10 ай бұрын
Clear and concise! Thank you!
@ProlificOaktree10 ай бұрын
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!
@ServantStatusMinistries4 ай бұрын
Thank you so much this was so helpful and straight to the point!!!
@ProlificOaktree4 ай бұрын
Glad it helped you out!
@mailnupurbhandari5 ай бұрын
such clear and easy to follow instructions .
@ProlificOaktree5 ай бұрын
Glad it was helpful!
@akshaygole71959 ай бұрын
On point. No time waste. Thanks
@longnguyenkim73362 ай бұрын
very useful tips and clear direction, thank you
@ProlificOaktree2 ай бұрын
Glad it was helpful!
@Yiannis_Lucacos8 ай бұрын
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?
@ProlificOaktree8 ай бұрын
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.Yesufe4 ай бұрын
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
@HeatherRogersMagic4 ай бұрын
Thank you! This was so validating!
@erikjohannes11 ай бұрын
Thx! Very helpful and to the point video.
@ProlificOaktree11 ай бұрын
Anytime!
@Readerpaige12 ай бұрын
Thank you this was very helpful!
@ProlificOaktree2 ай бұрын
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!
@kitturamu4 ай бұрын
Thank you so much, it helped me a lot.
@ProlificOaktree4 ай бұрын
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.
@codingdragons4 ай бұрын
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.
@ProlificOaktree4 ай бұрын
Not that I know of
@codingdragons4 ай бұрын
@@ProlificOaktree thank you!
@silvestrecamposano6317 Жыл бұрын
Thank you again, Sir!...
@christinataylor73827 ай бұрын
Hi! This was very helpful. You mentioned a video on date DIV for passage of dates, but I can't find the video
@ProlificOaktree7 ай бұрын
I think it was this video. kzbin.info/www/bejne/oZPdoKFjgq6oq7Mfeature=shared
@user-uf6el6hd9h Жыл бұрын
Super helpful!
@Sisa-fm8dm7 ай бұрын
ssoooo helpful! thank you so much sir for this video 🙏
@sumanthiyengar96416 ай бұрын
I was in shock when you told Feb 13th 2023 only difference is that I'm watching it in 2024, same date🥶
@ProlificOaktree6 ай бұрын
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.
@joanmiquelferrer212417 күн бұрын
I wonder if it is possible to select a date with the keyboard from the calendar pop-up. Thanks!
@ProlificOaktree17 күн бұрын
I don't think so.
@user-vq8ws6go8g11 ай бұрын
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?
@ProlificOaktree11 ай бұрын
Look into the settings and change your Locale
@wolfi20277 ай бұрын
Perfect thank you. Does there also exist a way to add a Pop-Up Timer Wheel?
@ProlificOaktree7 ай бұрын
No, I wish.
@Davidahernchannel11 ай бұрын
Perfect many thanks!
@ProlificOaktree11 ай бұрын
👏🏽
@user-tw2td4cm3d6 ай бұрын
This was helpful, thankss
@brianjaffe874710 ай бұрын
Nice job, you got my sub
@ProlificOaktree10 ай бұрын
Awesome, thanks!
@RedEyedJEdi4108 ай бұрын
Thank you for this!
@ProlificOaktree8 ай бұрын
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!
@tirthyatra55285 ай бұрын
Thank you so much! 🙏
@ProlificOaktree5 ай бұрын
You're so welcome!
@TheKirstebee8 күн бұрын
thanks so much!
@ProlificOaktree8 күн бұрын
You're welcome!
@ValueEnvision-Andreya10 күн бұрын
Thank you so much
@ProlificOaktree8 күн бұрын
You're most welcome
@zerokhan8584 ай бұрын
thank you so so so much!!!!!
@ProlificOaktree4 ай бұрын
Anytime!
@iggymach9 ай бұрын
nailed it. Thanks man
@ProlificOaktree9 ай бұрын
You bet!
@victoriasvibesss10 ай бұрын
thank you
@ProlificOaktree10 ай бұрын
You’re welcome!
@lylestavast765211 ай бұрын
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 ...
@ProlificOaktree11 ай бұрын
This may help. Google Sheets - Show the Day of the Week as Text kzbin.info/www/bejne/aZqXg5p5j9CLoqM
@33ZackG3 ай бұрын
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!
@ProlificOaktree3 ай бұрын
You can't change the default behavior.
@joanmiquelferrer212417 күн бұрын
With the second method, just pressing the intro key lets the calendar pop-up open.
@swarupmazumder9 ай бұрын
Thank you 😃
@ProlificOaktree9 ай бұрын
No problem!
@schweizerjoenzsevero46468 ай бұрын
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?
@olivianavarro91467 ай бұрын
I need this too! How do we select a different year without having to scroll through all the months?
@adayinlife101Ай бұрын
Thanks
@ProlificOaktree23 күн бұрын
Welcome
@pinnang50826 ай бұрын
thanks!
@ProlificOaktree6 ай бұрын
Welcome!
@electricloco-yt9zeАй бұрын
i want change th format of date like dd/mm/year
@ProlificOaktree23 күн бұрын
Do it with number formatting from the menu.
@sparkleegrl5 ай бұрын
Does this exist in the exact way for Excel?
@ProlificOaktree5 ай бұрын
Nope!
@ikkie272510 ай бұрын
How do I change the formatting to day-month-year instead of moth-day-year?
@ProlificOaktree10 ай бұрын
Format, Number, Custom date and time
@poojanavi5101 Жыл бұрын
that was greate
@ProlificOaktree Жыл бұрын
Thanks!
@taifurislam39974 ай бұрын
How to do that 2nd option in excel 2021? I can do in 2019 but can't in 2021
@ProlificOaktree4 ай бұрын
Excel is for boomers!
@اطفال20242 ай бұрын
how to double click at google sheet with mobile app
@ProlificOaktree2 ай бұрын
You can't get the pop-up calendar on mobile.
@muhammadridzuanbinnordinkp696411 ай бұрын
When using mobile, this doesn't work on iPhones as no Calendar pops up when double clicked. Please help...
@ProlificOaktree11 ай бұрын
It doesn't do it on mobile. Probably not the answer you wanted.
@SolangeWaithe9 ай бұрын
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
@ProlificOaktree23 күн бұрын
Check your spreadsheet location settings or just change the number format.