Excel 2010+ Date Selector

[Legacy 260385]

Hello, I would like to know if it is possible to create a date selector that is associated with a particular cell instead of manually typing in a date?

I currently use Microsoft Excel 2013 but the spreadsheet that I am creating with will most likely be used on Excel 2010 (saying that in case there may be any compatibility issues)

Thanks

 

[bschwartz]

It might be. What kind of date would you like to see in the dropdown list?

 

[Legacy 260385]

Something like this:

Thank You

 

[bschwartz]

Oh I see... I don't know how to do that. Perhaps someone else...

 

[Smitty]

Welcome to the Board!

You can use the Date/Time Picker control:

http://www.mrexcel.com/forum/excel-questions/614783-date-time-picker-excel-2010-a.html

HTH,

 

[Legacy 260385]

Thanks for trying bschwartz, I appreciate it

 

[Legacy 260385]

Thanks Smitty!!