Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

1 Answer 1

up vote 1 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

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.