+ Reply to Thread
Results 1 to 2 of 2

Scheduling Calendar

  1. #1
    Registered User
    Join Date
    01-14-2011
    Location
    Gig Harbor, WA
    MS-Off Ver
    Excel 2010
    Posts
    24

    Scheduling Calendar

    This calendar was developed by Whizbang a while ago. I've left a post on the original thread but wanted to see if anyone else could solve my issue.

    This calendar is great! It is almost exactly what I need. I was wondering if there was a way to add a second date for each event. I appraise real estate and I need to keep track of not only the day I inspect the property but also the day the report is due to my client. I've been trying to figure it out for the last couple hours but I'm not familiar enough with the "INDEX" function to figure out what's going on in this spreadsheet.

    Ideally I would like to have each event on the calendar twice with maybe the second time having some sort of signifier, like the cell being highlighted to indicate it is the due date and not the inspection date. I could probably figure this out if the first part was done.

    Thanks for the help!
    Brian
    Attached Files Attached Files

  2. #2
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: Scheduling Calendar

    The quick and easy solution would be to simply enter in the due date as another calendar item.

    The more complex solution would be to:

    1: Add a CalendarItemDueDates named range that corresponds to a column.
    2: Change the formula in the J:P columns to this (note you will need to adjust for each week and that it is an array formula and so confirmed with CTRL+SHIFT+ENTER):
    Please Login or Register  to view this content.
    3:Add in this conditional formatting formula (note you will need to adjust for each week):
    Please Login or Register  to view this content.
    See attached.
    Attached Files Attached Files
    Last edited by Whizbang; 06-13-2012 at 02:54 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1