LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default Need help with calendars...Please!

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calendars Rick Duley Excel Discussion (Misc queries) 1 November 29th 07 12:28 AM
calendars CJ Excel Discussion (Misc queries) 1 September 17th 06 09:31 PM
calendars CJ Excel Discussion (Misc queries) 2 September 16th 06 07:34 PM
Calendars Booklady28 Excel Discussion (Misc queries) 1 August 31st 06 01:56 AM
calendars Jerry Setting up and Configuration of Excel 1 May 4th 06 09:06 AM


All times are GMT +1. The time now is 12:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"