Hello,
I’m looking for a way to create a calculated column that does the following
Startdate = 7/23/2015
Days requesting = 3
column calculates the date returning but includes/knows when a weekend occurs
Date returning = 7/28/2015
Is there a way I can create that? Â Maybe something like =Weekday[startdate] + [days requesting])
Please advise, there has to be an easy function, no?
In SharePoint Online (UK dates) The days are numbered 1 to 7 (Sun to Sat). To check your setting create a custom list add “Start Date” column, and add custom column “DayNumber” as calculated field =WEEKDAY[Start Date]) in number format.
Based on this you can use a formulae with nested IF statements to identify Sun and Sat. Like this:
=IF(WEEKDAY[Start Date]+3)=1,[Start Date]+4,IF(WEEKDAY[Start Date]+3)=7,[Start Date]+5,[Start Date]+3))
If start date plus 3 is Sunday is TRUE add 4 days
ELSE IF start date plus 3 is Saturday is TRUE add 5 days
ELSE start date plus 3
Maybe not perfect and needs some correction, but I hope the logic provides some clues.
Does not account for holidays which I think someone used a look up list of dates to resolve, though I have not looked very hard.
Mike B
