S
Shaka215
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!
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!