I need to generate a calendar in which it is in a monthly format for 3 years.
In which I can dictate a work week weather it is Sun-Thurs or mon-Fri or
whatever days I select. Then I need to enter any holidays for a given year,
and be able to have it highlight a given work day or selection of workdays.
For example if I want it to find work day 6 for every month. It should be
able to count out the work days based on the work week selection and skip the
count of any holidays and then highlight the 6th day for example for
september in the US the 6th workday on a M-F workweek would be September
8Th. Any formulas for calculating out this logic.

I can walk you through creating the first part, a calendar that starts with a
year and month you give it ("2008" and "9", for example) and displays the
traditional five-week calendar with blank boxes at the beginning and end and
1 and 31-or-whatever falling on the correct days of the week for that month.
The rest of that stuff you may have to ask someone else about, or work out
after you've made the basic calendar. Or have you already got that far?

--- "tony" wrote:
I need to generate a calendar in which it is in a monthly format for 3 years.
In which I can dictate a work week weather it is Sun-Thurs or mon-Fri or
whatever days I select. Then I need to enter any holidays for a given year,
and be able to have it highlight a given work day or selection of workdays.
For example if I want it to find work day 6 for every month. It should be
able to count out the work days based on the work week selection and skip the
count of any holidays and then highlight the 6th day for example for
september in the US the 6th workday on a M-F workweek would be September
8Th. Any formulas for calculating out this logic.