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

In my SharePoint list I have a default due date of

=Today+10

How can I get this default date to be 10 working days from today?

I'm not too worried about taking into account public holidays etc, taking into account Saturday and Sunday would be sufficient

share|improve this question
up vote 2 down vote accepted

If you assume that the item is created on a working day then adding 10 working days is easy as it's two weeks. So the following should work

=Today+14

If it's not a full number of working weeks then you need to use IF on Weekday(Today) see Working Days, Weekdays and Holidays in SharePoint Calculated Columns

share|improve this answer
    
That's so obvious I feel a bit daft I didn't think of that myself, thanks :) – Enilorac Feb 26 '13 at 9:23

You can fix that problem with an if

=if(weekday(Today + 10,2)=6,Today + 10 + 2,if(weekday(Today + 10,2)=7,Today + 10 +1,Today + 10)
share|improve this answer

Your Answer

 
discard

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.