Excel Guru Needed to Build Calendar

Discussion in 'Programming' started by mcmuney, Jul 23, 2009.

  1. #1
    I need to get a calendar built in Excel with the following functions. If can do this, PM me with your price.

    Calendar Sheet
    1-this is where the calendar can be viewed and/or printed
    2-the month and year will be selected from 2 drop-downs and based on the selection, it will display that month/year calendar
    3-the calendar should begin with day -5 of the previous month and end with the last of day of the current month (this should be easily changeable, lets say if later I want it to start with day -7)
    4-in addition to the dates, the calendar should also specify what work day it is; for example, all week days are considered a workday, excluding holidays; therefore, if the 1st is a Tuesday, it is day 1, the 31st of the previous month would be a Monday and day-1. I can explain this in more detail if necessary.
    5-the calendar needs to display events on their respective dates from the Events Sheet (this will be the most complex build).

    Holiday Sheet
    1-in order to exclude holidays from being business days, there needs to be a Holiday Sheet to specify what dates are considered holidays. These dates should be excluded from being counted as a workday.

    Events Sheet
    -need to figure out the best way to build the structure as certain events will repeat on certain business days. for example, event1 may be one time on 7/25/09; however, event2 will occur on every work day 2; therefore, somehow needs to be inputted only once, rather then multiple times.

    Let me know.
     
    mcmuney, Jul 23, 2009 IP