Code for my Monthly calendar..!!!!

[bill]

I have a small monthly calendar that has some code for the days, but seems
to be a problem, it doesnt sometimes know how many days in the month...It is
a small program. If you want to look at it Ill be glad to send it.. Btw its
excel 2000..Bill

 

[steve]

not sure what your trying to accomplish but you dont need
to use code to find out the number of days in the month


use this formula to find the days in the current month

=day(eomonth(now(),0))


this will give you the number of days in a month

=day(eomonth(date(2003,12,1),0))


if you want a copy of a xl spread sheet that will create a
calander for any givin month email me and ill send you one