SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

3I'm creating a calendar that lists various recurring due dates for reports and status updates. For end-of-year reports, I choose the "Last weekday of December" option. However, 31 Dec is a company holiday. I'd like to have this report fall due on 30 Dec.

While I could easily do this with a lookup on the exisiting dueDate fields and an calculated "newDueDate-takingCompanyHolidaysIntoAccount" column, I'm wondering if there's a way to access the list(s) that populate the's calendar "add new task" dialog box to save that extra step?

I would like to define an additional menu option; last workday of the month with a list of company holiday dates. I could then define dueDate as such:

dueDate = if ((lastWeekday is-in-holidayList) and (lastWeekday = "Monday")) then dueDate = dueDate - 3 else dueDate - 1;

...recursively until my dueDate fell on a workday.

Any ideas?

share|improve this question
I would be astonished if you could modify both how the recurrence data is setup and how its interpreted expand the recurring events to display on the calendar/lists. – Ryan Jun 27 '12 at 8:07
On one hand, that's what I'm afraid of. On the other hand, I've found so much stuff that I ~can~ change, either through buried menu settings or programatically, that who knows? We may all be astonished. :) – dwwilson66 Jun 27 '12 at 23:55
up vote 0 down vote accepted

I finally did confirm, definitively, that calendar recurrence data cannot be changed anywhere. I ended up creating to identical tasks with different start dates to simulate the modification I was unable to make.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.