Somehow I forgot this You Tube presentation and struggled for a few years without this functionality. Now, hopefully permanently bookmarked this TeachExcel channel
thank you for this! this, by far, is the only one working and the simplest one. I have been searching for a date picker for almost three hours and the only ones I have found are those that require coding in excel vba. thank you so much for this! it is indeed a life-saver, great job!
This is BRILLIANT! I've tried the built-in several times and got very frustrated when I couldn't make it work. This tool no time to install and works great. If you type "Date" in a cell with no formatting and click on the cell below it, it shows up. Gamechanger
I have Excel 2010 and put the .xlam file in XLSTART. The DatePicker worked without further setup after restarting Excel and after a PC restart; so that configuration looks reliable. Certainly the DatePicker is very good, and makes entering dates really easy. Thanks to TeachExcel for a great recommendation. Also thanks for a really well modulated course delivery and an ideal tone and speed for me.
Exactly what I was looking for to build a budgeting and money tracker sheet. I agree... why is this not already a part of excel? Very useful. Thanks again. :)
Thank you so much for sharing this Macro! It worked perfectly and saved me a lot of time and effort. I really appreciate your hard work and dedication to helping others. Keep up the great work!
Outstanding! Your instructions are clear and easy to follow. I love this app! (My co-workers think our IT department is dense, but I'm a goddess for adding it to our spreadsheets LOL!)
I am very glad to hear this! I have many tutorials that are not too tough that you might want to take a peak at, I call them Excel Quickies and you might find them helpful :) ua-cam.com/play/PLxhsXZXQXrUBRG1QskvchMBezTR9ZTWaj.html
I don't know why this worked like this but when I unzipped the file and Excel was already open the Excel program automatically asked me if I would like to use the add-in and I clicked yes and it's been work for the last 30 minutes, lol. I have opened several other Excel files and I shut Excel down completely and then re-opened and the date picker is working excellent. Thank you
This video was so so helpful. I asked my team leader if there's a way of putting in a date and she said she don't don't. Well, then google was my best friend and I came across this video and walla. I have now installed date picker and followed the process and now I'm enjoying date picker...I still need to decide whether I'm going to share my date picker information, lol🤣😂
My kudos to *Mr. Excel Bill Jelen* whose books I ordered for our university's library in the past. My heartfelt and sincere thankyou to *Sam Radakovitz* who is the genius brain behing the *Date Picker Excel Add-in* compatible with Excel 2007 and beyond. Excel enthusiasts all over the world and the global Excel community at large are grateful to you. God Bless Both of You!
Also the endeavor of all the other Excel gurus is deeply appreciated... You are the guys who render EXCEL the most fantastic SW developed by mankind on the face of the Earth. Just to name some of them here (the list is absolutely inexhaustive and I apologize to those masters and gurus whom I may have forgotten to cite):
(without any particular order) --- *Prof. Dr. Wayne L. Winston* from Kelley School of Business at Indiana University, Bloomington/USA, and Bauer College at the University of Houston/USA, --- *Prof. Dr. S. Chris Albright* from Kelley School of Business at Indiana University, Bloomington/USA, --- *David Ringstrom* from Atlanta, Georgia/USA ( www.accountingweb.com/profile/david-ringstrom & www.studentsexcel.com ) --- *Chandoo* from India and Wellington/New Zealand, ( www.Chandoo.org ) --- *Mynda and Phil Treacy* from Australia, ( www.MyOnlineTrainingHub.com ) --- *Leila Gharani* from Vienna in Austria, ( www.XelPlus.com ) --- *Mike 'Excelisfun' Girvin* from Oregon/USA, ( ua-cam.com/users/excelisfun ) --- *Dave and Laura Bruns* from Salt Lake City, Utah/USA, ( www.ExcelJet.net ) --- *Oz du Soleil* from Portland, Oregon/USA, ( www.OzduSoleil.com/vlog/ ) --- *Debra Dalgleish* from Toronto/Canada, ( www.Contextures.com ) --- *Jon Acampora* from Huntington Beach, California/USA, --- *Ray Colon* from New York City/USA, ( ua-cam.com/channels/XwkXHzl6Ajyuhc5GaflKsg.html ) --- *Sumit Bansal* from India ( www.TrumpExcel.com ) --- *Bob Flisser* , the guru who has unboxed the Scenario Analysis tool of Excel, --- *John Franco* from Ecuador ( www.Wizdoh.com ), --- *Allen Wyatt* from Mountain View, Wyoming/USA ( excel.tips.net/ ), --- *John Michaloudis* , the Chief Inspirational Officer from Bilbao Area/Spain and from Australia of Greek origin ( www.MyExcelOnline.com )
Nice! Thanks for this tip. The built-in ActiveX Microsoft Date and Time Picker control is definitely quirky. This is a good alternative. Too bad MS does not copy it for the internal functionality. Thanks for sharing it and the tips to set it up. Thumbs up!
I do not normally trust free software downloaded from the web, so before I installed this add-in I checked the code and it is well written and seems to be without malicious code. It is an excellent little add-in. Downloaded from the indicated web site on 19 March, 2020.
I think perhaps you're a bit paranoid, I definitely see your point of view, but definitely paranoid I think, the add in is from a person that works at excel..........
@@redangrybird7564 Yea I mean, that's never happened to me. And again, the guy works for excel. Since that's the case, fool is a harsh and unrealistic word to use. I'm just saying your efforts would be better spent in other areas, than worrying about a virus to hurt your computer that you think a guy from Excel made to hurt your computer lol. It's a joke. If a guy who works at excel, who is owned by Microsoft is creating malicious viruses to harm others computers, than I guess we are all infected right? I mean what are you wasting your time on this for.... Lol, good luck to you.
![How To Add 3 Different Date Picker Calendars in Microsoft Excel [Free Download]](/img/n.gif)
VBA/Macros Course (40% Discount): www.teachexcel.com/vba-course-update.php?src=youtube_v_description_pinned_comment_6chyTSbIo6k
Me, again, I've just installed it. It has solved the most irritating issue that i have had with spreed sheets. I've sat back and laughed. Thank you
As you predicted, I ran into the problem. I am glad you were thoughtful enough to include the fix in your vid!
You ROCK! I watched 6 videos before I found your very EASY and CONVENIENT way to insert a date picker! THANK YOU
Watching in 2023. This is exactly what I needed, and as a bonus, it's trusted. It shows up every time I open Excel
You are the most awesome!!!! I have been looking for the most simple date picker in Excel and thanks so much I found you!! You are my saviour!!!
this is the best, simplest & effective method. thanks a lot
Somehow I forgot this You Tube presentation and struggled for a few years without this functionality. Now, hopefully permanently bookmarked this TeachExcel channel
I'm very glad to hear it :)))) Welcome to the Future! haha
This is the most helpful and easiest instruction to add a date picker. Thank you SOOOOO much!
This is exactly what I was looking for. This is the most helpful and easiest instruction to add a date picker. Thank you SO much!
thank you for this! this, by far, is the only one working and the simplest one. I have been searching for a date picker for almost three hours and the only ones I have found are those that require coding in excel vba. thank you so much for this! it is indeed a life-saver, great job!
Super Amazing!!!
Thanks TeachExcel!!
Easy my job and help me to avoid choose wrong date
This is BRILLIANT! I've tried the built-in several times and got very frustrated when I couldn't make it work. This tool no time to install and works great.
If you type "Date" in a cell with no formatting and click on the cell below it, it shows up.
Gamechanger
buddy you know how long ive been looking for this...not everyone has the one that you have with this awesome date picker...THANK YOU
This is the BEST!!!! Thank you for making life easy!!! I spent so much time trying to figure out the other way!!
Thank you, you are like the Bob Ross of excel, so soothing
bahaha that's the first time I heard that and I love it :D
I have Excel 2010 and put the .xlam file in XLSTART. The DatePicker worked without further setup after restarting Excel and after a PC restart; so that configuration looks reliable.
Certainly the DatePicker is very good, and makes entering dates really easy. Thanks to TeachExcel for a great recommendation.
Also thanks for a really well modulated course delivery and an ideal tone and speed for me.
Exactly what I was looking for to build a budgeting and money tracker sheet. I agree... why is this not already a part of excel? Very useful. Thanks again. :)
You are the best. Simple and efficient
Thanks... it worked as you mentioned in video...
That was amazing, I used to hate updating my calendar, now it’s so easy. Thank you very much
Thank you so much. It’s just awesome! 🙂
Every thing is clear like pure water ................Thanks
hahaha I love this description!!!
Thaaaaaaank You.....Very easily explained. I also used to "not like inputting dates"
This was a great help after other attempt failed Thanks!
Thank you so much for sharing this Macro! It worked perfectly and saved me a lot of time and effort. I really appreciate your hard work and dedication to helping others. Keep up the great work!
How is a date picker not part of excel core function????? This is so basic, I can't believe we have to go through hacks to implement this.
I agree with your comment 10000000%!!!
It was AWESOME and VERY COOL!!! ))
I'm a Landlord, this add-on is what I have needed for years in my spreed sheet, Thanks.
Glad to help :))
Thank you so much, great help. I 've been trying this since yesterday with no luck.
Outstanding! Your instructions are clear and easy to follow. I love this app! (My co-workers think our IT department is dense, but I'm a goddess for adding it to our spreadsheets LOL!)
Awesome!! Just installed...thank you!
This is the only addin that I still use - glad you go it too!
Thanks for the great video.
excellent solution given to me tq very much sir
This is great! Excel is not my strength but I was able to follow along. Thank you!!
I am very glad to hear this! I have many tutorials that are not too tough that you might want to take a peak at, I call them Excel Quickies and you might find them helpful :)
ua-cam.com/play/PLxhsXZXQXrUBRG1QskvchMBezTR9ZTWaj.html
Thank for this video. It helped me solve a problem I've been struggling with for a long while.
Thank you so much. It's works. ❤
I don't know why this worked like this but when I unzipped the file and Excel was already open the Excel program automatically asked me if I would like to use the add-in and I clicked yes and it's been work for the last 30 minutes, lol. I have opened several other Excel files and I shut Excel down completely and then re-opened and the date picker is working excellent. Thank you
Wow, I wish my Excel worked so well hahah
Able to solve my problem... SUPERB
I from Brazil, thank you Master!! Muito obrigado.
Funktioniert wunderbar. Seltsam, dass Excel das nicht mitbringt.
Thanks man. made my life easy.
Thank you so much. This worked excellently!!!!
Thanks very useful and smart
thanks for add in . I like it
This video was so so helpful. I asked my team leader if there's a way of putting in a date and she said she don't don't. Well, then google was my best friend and I came across this video and walla. I have now installed date picker and followed the process and now I'm enjoying date picker...I still need to decide whether I'm going to share my date picker information, lol🤣😂
AWESOME! AWESOME! AWESOME! AWESOME!
Thank you very much for this great video and for this valuable informations , and for this simple, clear and wonderful method.
Glad you like it)
Works perfectly. Thanks.🎉
Thank you a lot, really appreciate
TY works perfect for excel 2013
Good video! It's also important to note that this is a macro as well, so it cannot be undone if used.
Easy peezy. thank you very much
works good on office 365 2020, many thks mate.
My kudos to *Mr. Excel Bill Jelen* whose books I ordered for our university's library in the past.
My heartfelt and sincere thankyou to *Sam Radakovitz* who is the genius brain behing the *Date Picker Excel Add-in* compatible with Excel 2007 and beyond.
Excel enthusiasts all over the world and the global Excel community at large are grateful to you. God Bless Both of You!
Also the endeavor of all the other Excel gurus is deeply appreciated...
You are the guys who render EXCEL the most fantastic SW developed by mankind on the face of the Earth.
Just to name some of them here (the list is absolutely inexhaustive and I apologize to those masters and gurus whom I may have forgotten to cite):
(without any particular order)
--- *Prof. Dr. Wayne L. Winston*
from Kelley School of Business at Indiana University, Bloomington/USA, and Bauer College at the University of Houston/USA,
--- *Prof. Dr. S. Chris Albright* from Kelley School of Business at Indiana University, Bloomington/USA,
--- *David Ringstrom* from Atlanta, Georgia/USA ( www.accountingweb.com/profile/david-ringstrom & www.studentsexcel.com )
--- *Chandoo* from India and Wellington/New Zealand, ( www.Chandoo.org )
--- *Mynda and Phil Treacy* from Australia, ( www.MyOnlineTrainingHub.com )
--- *Leila Gharani* from Vienna in Austria, ( www.XelPlus.com )
--- *Mike 'Excelisfun' Girvin* from Oregon/USA, ( ua-cam.com/users/excelisfun )
--- *Dave and Laura Bruns* from Salt Lake City, Utah/USA, ( www.ExcelJet.net )
--- *Oz du Soleil* from Portland, Oregon/USA, ( www.OzduSoleil.com/vlog/ )
--- *Debra Dalgleish* from Toronto/Canada, ( www.Contextures.com )
--- *Jon Acampora* from Huntington Beach, California/USA,
--- *Ray Colon* from New York City/USA, ( ua-cam.com/channels/XwkXHzl6Ajyuhc5GaflKsg.html )
--- *Sumit Bansal* from India ( www.TrumpExcel.com )
--- *Bob Flisser* , the guru who has unboxed the Scenario Analysis tool of Excel,
--- *John Franco* from Ecuador ( www.Wizdoh.com ),
--- *Allen Wyatt* from Mountain View, Wyoming/USA ( excel.tips.net/ ),
--- *John Michaloudis* ,
the Chief Inspirational Officer from Bilbao Area/Spain and from Australia of Greek origin ( www.MyExcelOnline.com )
Perfect! It's better than other tutorials. Thank you. ;)
Thank you so much.
Thanks for sharing. Very useful.
Thank you Sir. That is very useful for me.
Soooo helpful. Thank you.
What an awesome tool...thanks!
You are so kool! Love the tutorial!!! Oh and especially the new add in 😁
Great video, extremely helpful and worked like a charm!
Thanks a lot for this great hack!
Awesome stuff, thank you so. I've gone through UA-cam for almost an hour & all the other stuff wasn't working.
Excellent Video. I still can't believe this is not a built-in feature in excel... Seriously Microsoft?
Fantabulous, Such a simplest way...
Thank you so much
Merci bcp pour cette vidéo.
This add-in was made by Jankenstein Corp.
Nice! Thanks for this tip. The built-in ActiveX Microsoft Date and Time Picker control is definitely quirky. This is a good alternative. Too bad MS does not copy it for the internal functionality. Thanks for sharing it and the tips to set it up. Thumbs up!
Totally agree! When I was looking for alternatives online and saw this Samradapps one, it felt so natural compared to the Activex crap.
Thank you it works easily
Thank you!
I do not normally trust free software downloaded from the web, so before I installed this add-in I checked the code and it is well written and seems to be without malicious code.
It is an excellent little add-in. Downloaded from the indicated web site on 19 March, 2020.
I think perhaps you're a bit paranoid, I definitely see your point of view, but definitely paranoid I think, the add in is from a person that works at excel..........
@@arayahomes4308 Better paranoid than sitting on my desk like a fool, crying that my data was wiped out by a virus or a trojan 😀✌
@@redangrybird7564 Yea I mean, that's never happened to me. And again, the guy works for excel. Since that's the case, fool is a harsh and unrealistic word to use. I'm just saying your efforts would be better spent in other areas, than worrying about a virus to hurt your computer that you think a guy from Excel made to hurt your computer lol. It's a joke. If a guy who works at excel, who is owned by Microsoft is creating malicious viruses to harm others computers, than I guess we are all infected right? I mean what are you wasting your time on this for.... Lol, good luck to you.
Easy to do and thanks for posting
You're very welcome)
Thanks sir for this amazing trick
Thank You this make my Life Good!
Thank You! Please explain how to pick and drop data in a cell in excel to another cell.
Thanks your helpful share. Big salute to you
Thank you for sharing....jus made my life a whole lot easier
Super, it works fine
i happy to install. very useful to quick work. thanks
Wow, fantastic, thank you so much for sharing this!
Much thanks 🙏
WOW !!! Works great. Thanks so much!
You're very welcome! Glad you like it :)
Awesome! Great help mate! thanks..
Awesome stuff. Excellent and brilliant.
Thank you so much!!! this is truly amazing help and great tutorial
Great stuff
Excellent. Thanks a lot.
Fantastic, it works
Glad to help :)
I have just installed it . It's very interesting i like it so much Thank you so
You're welcome)
thanks for your reply. Regards martin
That was really cool!!
Amazing. Thanks you very much.!!!
nice clean date picker. unfortunatly wont work with os/365 i7 ot m1:-( sent note to sam. hope he has a solution for me. liked you video.
Thank you
Worked Perfect thank you!
Nice one. Super..
Thanks its so useful