Date Drop Down Menu
 

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

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


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

--
rbrickl
------------------------------------------------------------------------
rbrickl's Profile: http://www.excelforum.com/member.php...o&userid=35910
View this thread: http://www.excelforum.com/showthread...hreadid=557096

Date Drop Down Menu
 

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" wrote:


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

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


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

--
rbrickl
------------------------------------------------------------------------
rbrickl's Profile: http://www.excelforum.com/member.php...o&userid=35910
View this thread: http://www.excelforum.com/showthread...hreadid=557096

Date Drop Down Menu
 

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

Thanks


--
rbrickl
------------------------------------------------------------------------
rbrickl's Profile: http://www.excelforum.com/member.php...o&userid=35910
View this thread: http://www.excelforum.com/showthread...hreadid=557096