Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey!
I am in need of a worksheet that will display all the days in a month in one column based on the values selected in two drop down boxes. These two drop down boxes will be obviously the month and the year. The reason why I can't just use the normal VB calendar plug-in is because even using a date in one cell I end up with the months that have either more then 28 days or 31 days in it so its not a matter of having a date in cell A1 and having 29 more cells underneath of it with the value of =SUM(A1+1) because if it is February the first few days of March would be displayed. I need the spreadsheet to just display only the days that are in a month and not display the date in the next month. I need the drop down boxes to work with displaying only the days in a particular month and the ability to not show dates in the next month... 1.) Drop down boxes to allow the end user to select a month and year (I can do this part). 2.) All the dates in one column (this I cant figure out) 3.) Only showing dates in the month selected from the drop down boxes Any help is much appreciated!!! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calendars | Excel Discussion (Misc queries) | |||
calendars | Excel Discussion (Misc queries) | |||
calendars | Excel Discussion (Misc queries) | |||
Calendars | Excel Discussion (Misc queries) | |||
calendars | Setting up and Configuration of Excel |