Somehow I forgot this You Tube presentation and struggled for a few years without this functionality. Now, hopefully permanently bookmarked this TeachExcel channel
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.
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!
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. :)
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
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, ( ruclips.net/user/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, ( ruclips.net/channel/UCXwkXHzl6Ajyuhc5GaflKsg ) --- *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 )
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🤣😂
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 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.
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 :) ruclips.net/p/PLxhsXZXQXrUBRG1QskvchMBezTR9ZTWaj
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 made my own "Date Picker" as a form to use within other forms, etc. Add-ins arent a good way to go about trying to solve things when you're in a company environment that you may not have permissions to go about installing things as an end-user on the network.
I have 2 questions, 1. Is it possible to make the datepicker show up ONLY in the field to the right of cell where you want the date to appear? 2. Do I need to install datepicker on every system in order for it to show up? IE, I am doing some independent contract work and have the Datepicker addon installed on my system. Would the client need to have it installed on their system in order for it to show up?
Very informative with clear concise instructions. What should I do if I want to share the formatted template with someone who has not installed a date picker on their PC?
You should be able to send the add-in file itself to anyone you want but they will then need to follow the installation instructions to get it to work - don't forget to "unblock" the file in Windows so you can use it after the first time it is installed.
As i think first your friend must download the add in file and then the instalation on the excel program following the Teach excel instructions of course.
VBA/Macros Course (40% Discount): www.teachexcel.com/vba-course-update.php?src=youtube_v_description_pinned_comment_6chyTSbIo6k
Watching in 2023. This is exactly what I needed, and as a bonus, it's trusted. It shows up every time I open Excel
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!
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 exactly what I was looking for. This is the most helpful and easiest instruction to add a date picker. Thank you SO much!
You ROCK! I watched 6 videos before I found your very EASY and CONVENIENT way to insert a date picker! THANK YOU
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.
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%!!!
This is the most helpful and easiest instruction to add a date picker. Thank you SOOOOO 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!
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
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. :)
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
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
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, ( ruclips.net/user/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, ( ruclips.net/channel/UCXwkXHzl6Ajyuhc5GaflKsg )
--- *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 )
That was amazing, I used to hate updating my calendar, now it’s so easy. Thank you very much
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🤣😂
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'm a Landlord, this add-on is what I have needed for years in my spreed sheet, Thanks.
Glad to help :))
Every thing is clear like pure water ................Thanks
hahaha I love this description!!!
Good video! It's also important to note that this is a macro as well, so it cannot be undone if used.
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!
Super Amazing!!!
Thanks TeachExcel!!
Easy my job and help me to avoid choose wrong date
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 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.
This add-in was made by Jankenstein Corp.
Thanks... it worked as you mentioned in video...
Thaaaaaaank You.....Very easily explained. I also used to "not like inputting dates"
Thank you so much, great help. I 've been trying this since yesterday with no luck.
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 :)
ruclips.net/p/PLxhsXZXQXrUBRG1QskvchMBezTR9ZTWaj
Thank you so much. It’s just awesome! 🙂
Thank for this video. It helped me solve a problem I've been struggling with for a long while.
You are the best. Simple and efficient
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.
This was a great help after other attempt failed Thanks!
excellent solution given to me tq very much sir
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)
Awesome!! Just installed...thank you!
This is the only addin that I still use - glad you go it too!
Funktioniert wunderbar. Seltsam, dass Excel das nicht mitbringt.
One more point is there. Just write "Date" in any cell you can see the date pick calendar in the next cell below in the same colum.
Excellent Video. I still can't believe this is not a built-in feature in excel... Seriously Microsoft?
TY works perfect for excel 2013
It was AWESOME and VERY COOL!!! ))
Thank you so much.
Thanks for the great video.
I from Brazil, thank you Master!! Muito obrigado.
Thank you so much. It's works. ❤
Awesome stuff, thank you so. I've gone through RUclips for almost an hour & all the other stuff wasn't working.
Able to solve my problem... SUPERB
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.
Thanks very useful and smart
Thank you a lot, really appreciate
I made my own "Date Picker" as a form to use within other forms, etc. Add-ins arent a good way to go about trying to solve things when you're in a company environment that you may not have permissions to go about installing things as an end-user on the network.
can u share more then?
Do share
thanks for add in . I like it
works good on office 365 2020, many thks mate.
Easy peezy. thank you very much
Thank you!
Thank You! Please explain how to pick and drop data in a cell in excel to another cell.
Thank you so much
Thank you so much. This worked excellently!!!!
Thanks man. made my life easy.
Merci bcp pour cette vidéo.
I have 2 questions,
1. Is it possible to make the datepicker show up ONLY in the field to the right of cell where you want the date to appear?
2. Do I need to install datepicker on every system in order for it to show up? IE, I am doing some independent contract work and have the Datepicker addon installed on my system. Would the client need to have it installed on their system in order for it to show up?
In a sea of old comments I find yours, how to deploy to people giving the workbook to?
Works perfectly. Thanks.🎉
Its very difficult, when you are a "one man band" to learn how to use and develop a spreed sheet. Thank heavens for RUclips
Thank you
Much thanks 🙏
Thank You
This was helpful! How would I insert the date picker as a blank cell for creating a fillable form? it doesn't stay if I don't choose a date.
I have the same question
I also have this question. I'd like the date picker to be a drop box
If you make the blank cells formatted as a date it will automatically activate the date picker when you click inside that cell. :)
Soooo helpful. Thank you.
Thanks
Super, it works fine
Fantastic, it works
Glad to help :)
Very informative with clear concise instructions. What should I do if I want to share the formatted template with someone who has not installed a date picker on their PC?
What an awesome tool...thanks!
Thanks sir for this amazing trick
Thanks for sharing. Very useful.
Perfect! It's better than other tutorials. Thank you. ;)
You are so kool! Love the tutorial!!! Oh and especially the new add in 😁
Thanks a lot for this great hack!
Thank you Sir. That is very useful for me.
Can we place it on the userForms for DOB etc?
If so how... 😵
Great video, extremely helpful and worked like a charm!
I have just installed it . It's very interesting i like it so much Thank you so
You're welcome)
Thank you it works easily
Fantabulous, Such a simplest way...
Great stuff
OMG! Thank you!
You are very welcome Sharon :))
Will it work if i sent the installed add in file to my friend's pc? Or he or she need to install the add in too?
You should be able to send the add-in file itself to anyone you want but they will then need to follow the installation instructions to get it to work - don't forget to "unblock" the file in Windows so you can use it after the first time it is installed.
As i think first your friend must download the add in file and then the instalation on the excel program following the Teach excel instructions of course.
Thank you for sharing....jus made my life a whole lot easier
Thanks your helpful share. Big salute to you
Excellent. Thanks a lot.
Thank you so much for this vital information
thanks for your reply. Regards martin
Easy to do and thanks for posting
You're very welcome)