Can someone help modify an Excel Template such as adding a drop down calendar, drop down menu for time, etc. ?

I have attached a template that I need modified to my specifications. See screenshot for what needs to be modified. I am sure this is simple for an Excel expert, but that is not me. Can an expert please help me make the changes and attach it back to me? Thank you.

 patching-checklist-template.pngPatching-Checklist-v2.xlsx
joukiejoukAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamMicrosoft Excel ExpertCommented:
It is so simple

Go to Data tab

Then data validation

Then you can put the date or time or actual data validation from there
joukiejoukAuthor Commented:
Not to easy for me. I am not savvy with Excel.
joukiejoukAuthor Commented:
The only assistance I need help with is with the Date Picker and time drop down menu.  Can someone please provide assistance? I need this ASAP, and do not have the time to learn this or research it. Can someone just simply take the excel doc, and modify it and attach it back to me?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Roy CoxGroup Finance ManagerCommented:
There are simple calendars to add here. I can add  one to your workbook but not until I've finished work
joukiejoukAuthor Commented:
Yes, if you can help me modify the date picker and time picker, that would be great, Thank you.
joukiejoukAuthor Commented:
I have a 64 bit version of Office Plus 2013. From what I read, I will not have the option to insert a date picker in the Developer tool. I checked and it is not there. Can someone confirm this?

Also, can someone shed some light on how to add a time picker?
Roy CoxGroup Finance ManagerCommented:
As I said, I am working on this. You cannot use DateTimePickers in many versions of Excel so I am adding my own versions. I have been very busy at work but should have it finished soon.
joukiejoukAuthor Commented:
Thanks Roy. Much appreciated!
Roy CoxGroup Finance ManagerCommented:
I have added the drop down lists and a time picker and calendar. These are not ActiveX controls so they will work on any version of Excel. I think I have covered all the necessary columns but it is simple to make the controls appear for any other columns.
EE-Calendar---DatePicker.xlsm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.