Learn How to Enable Date Picker or Calendar Drop Down in Excel
Learn How to Enable Date Picker or Calendar Drop Down in Excel
In this video you will learn how to enable date picker or calendar drop down in excel. By enabling this we can easily enter dates in excel with correct date formatting.
#advanceexcel #excelformulasandfunctions
follow us in WhatsApp to learn more:
whatsapp.com/channel/0029Va8B...
Пікірлер: 32
Sir you are amazing! Thank You a lot!! I was struggling all this time typing manually the dates.
Hi thanks it's very easy to use
Wow! Its very useful add ins thank you so much!
@spreadsheet_power
7 ай бұрын
Welcome
hey this is John from Argentina, you are awesome, i love your content, thanks for the help!!! let me know if i can contribute with anything you need!
thank you, very well explained
@spreadsheet_power
10 ай бұрын
Welcome 🙏
Excellent Video
We love this date picker Thank you. The only issue we seem to be having is that the excel file that has the date picker is being used by multiple people in Teams and we are finding that the file takes a long time to open and gets hung up on your date picker file. Any suggestions?
perfect add-ons
Shukrani
Thanks for your help Brother....
@spreadsheet_power
Жыл бұрын
Welcome 🙏
Thank u👍
Tnxxx a lot bro 😎
@spreadsheet_power
2 жыл бұрын
Welcome
GREAT, THANKS
@spreadsheet_power
Жыл бұрын
Wc🙏
Thank you
@spreadsheet_power
5 ай бұрын
Welcome 🙏
Data validation, criteria is date (is a valid date) then save
which version of Excel are you using? Is there any compatibility issue in Office 2016? My Excel 2016 shows Mini Monthly Callander in the list of Add-ins which isn't working properly.
@spreadsheet_power
4 ай бұрын
I am using excel 365. There might be compatibility issues in old versions
I have MS Home 2010. The document didn't automatically appear in the Add-Ins list as yours did. I'm stuck.
Can I use it with MacBook
@spreadsheet_power
Жыл бұрын
I have not tried, I think it should work.
@rapoto
11 ай бұрын
It does not work on Excel 365 MacOS. While the Date Picker icon appears in the TOOL BAR, clicking on it resuts in an error: Visual Basic for Applications: Run-Time error '53': File not found: user32 @@spreadsheet_power
Why my excel said that "This fail type is not supported in Protected View"
@spreadsheet_power
4 ай бұрын
Need to remove protected view. After you open Excel, click on Enable editing option it shows just below the tools ribbon.
@kristyschiltz490
Ай бұрын
@@spreadsheet_power There is no Enable editing option that pops up