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!
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. :)
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
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 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
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?
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 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?
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.
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 )
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🤣😂
Wasted a whole day trying to figure out that "c:\windows\syswow64\mscomct2.ocx" crap that doesnt even work on all excel. This add-in is a gem! literally only took me 1 minute to add it in my excel. Thanks! If I send my excel file with the date picker to a another computer, will the add-in still work?
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 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.
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!
Hi Kevin. Thank you very much for your valuable lesson. I have an Excel data entry form with 68 fields. Users have saved the data entry forms. Is there any way that I can extract the data from those excel user data entry forms? Thank you very much again for your time & help
hey A great application, thank you. How can I adjust the calendar for the European time and date, namely: 1. How do I get the file xlam. 2. first day instead of Sunday Monday 3. format of the current day Thanks in advance
![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
You ROCK! I watched 6 videos before I found your very EASY and CONVENIENT way to insert a date picker! THANK YOU
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
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!
As you predicted, I ran into the problem. I am glad you were thoughtful enough to include the fix in your vid!
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 most helpful and easiest instruction to add a date picker. Thank you SOOOOO much!
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
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 the best, simplest & effective method. thanks a lot
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.
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
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. :)
This is the BEST!!!! Thank you for making life easy!!! I spent so much time trying to figure out the other way!!
Watching in 2023. This is exactly what I needed, and as a bonus, it's trusted. It shows up every time I open Excel
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
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%!!!
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
That was amazing, I used to hate updating my calendar, now it’s so easy. Thank you very much
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!)
Super Amazing!!!
Thanks TeachExcel!!
Easy my job and help me to avoid choose wrong date
You are the best. Simple and efficient
This was a great help after other attempt failed Thanks!
Thank you so much, great help. I 've been trying this since yesterday with no luck.
Thanks... it worked as you mentioned in video...
Thank for this video. It helped me solve a problem I've been struggling with for a long while.
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
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. :)
Good video! It's also important to note that this is a macro as well, so it cannot be undone if used.
Every thing is clear like pure water ................Thanks
hahaha I love this description!!!
Awesome!! Just installed...thank you!
This is the only addin that I still use - glad you go it too!
I'm a Landlord, this add-on is what I have needed for years in my spreed sheet, Thanks.
Glad to help :))
Thaaaaaaank You.....Very easily explained. I also used to "not like inputting dates"
Works perfectly. Thanks.🎉
Able to solve my problem... SUPERB
It was AWESOME and VERY COOL!!! ))
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?
Thank you so much. It’s just awesome! 🙂
Thank You! Please explain how to pick and drop data in a cell in excel to another cell.
多謝！
Thanks man. made my life easy.
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
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?
I from Brazil, thank you Master!! Muito obrigado.
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.
Thanks for the great video.
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 )
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)
Perfect! It's better than other tutorials. 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🤣😂
excellent solution given to me tq very much sir
Thank you so much. It's works. ❤
Will the date picker also work for the person you're sending it to
Soooo helpful. Thank you.
thanks for add in . I like it
Wasted a whole day trying to figure out that "c:\windows\syswow64\mscomct2.ocx" crap that doesnt even work on all excel. This add-in is a gem! literally only took me 1 minute to add it in my excel. Thanks! If I send my excel file with the date picker to a another computer, will the add-in still work?
Thanks a lot for this great hack!
Thanks very useful and smart
If you send a worksheet to someone who has not done the date picker download will it still work?
Can we place it on the userForms for DOB etc?
If so how... 😵
AWESOME! AWESOME! AWESOME! AWESOME!
What an awesome tool...thanks!
works good on office 365 2020, many thks mate.
Merci bcp pour cette vidéo.
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.
Excellent Video. I still can't believe this is not a built-in feature in excel... Seriously Microsoft?
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
You are so kool! Love the tutorial!!! Oh and especially the new add in 😁
Easy peezy. thank you very much
Great video, extremely helpful and worked like a charm!
Thank you Sir. That is very useful for me.
Easy to do and thanks for posting
You're very welcome)
Thank you it works easily
TY works perfect for excel 2013
Thank you so much
Fantastic, it works
Glad to help :)
This add-in was made by Jankenstein Corp.
Thank you for the great tip. I just wanted to know if I wanted to change the format to dd/mm/yyyy how would I do about doing this?
Thanks your helpful share. Big salute to you
Thank you a lot, really appreciate
Awesome! Great help mate! thanks..
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.
Hi Kevin. Thank you very much for your valuable lesson. I have an Excel data entry form with 68 fields. Users have saved the data entry forms. Is there any way that I can extract the data from those excel user data entry forms? Thank you very much again for your time & help
Excellent. Thanks a lot.
hey
A great application, thank you.
How can I adjust the calendar for the European time and date, namely:
1. How do I get the file xlam.
2. first day instead of Sunday Monday
3. format of the current day
Thanks in advance
I see that it can include the time what about the Day Abbreviation? Like MON TUE WED?
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.
Awesome stuff, thank you so. I've gone through UA-cam for almost an hour & all the other stuff wasn't working.
thanks for your reply. Regards martin
need this for excel on macbook
Loving this, but how can I make this work if my sheet is protected? I am trying to use this for a special order form for my team.
Fantabulous, Such a simplest way...
Thank you so much for this vital information
Dates are useful for the id primary like in MySQL
Thanks sir for this amazing trick
i happy to install. very useful to quick work. thanks
Is it functional for a shared excel file in sharepoint?
Thank you so much.
YOU ARE A LIFE SAVER!!!!!