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.