Date Drop Down Menu

[rbrickl]

I am having a problem with my date drop down menu. I want the menu t
show the month example (June) and not the exact date exampl
(06/06/06). I still want the data table to show the exact dat
though.

Attached is a word document of a better explanation with pictures o
what I want to do

+-------------------------------------------------------------------
|Filename: Date.doc
|Download: http://www.excelforum.com/attachment.php?postid=4959
+-------------------------------------------------------------------

 

[Hank]

There is an alternative I can come up

Create a now column, then use function =Month(A1), A1 = the date you have now
It return to number of the month, it maybe 6 for JUN, or 9 for Sept, then
you auto filter this column and choose 6 for all data for JUN.

Help it helps

Hank

 

[rbrickl]

This probably would not work because I print out these records and th
sheet would look unprofessional. If anyone else has a better ide
please offer your help.

Thank