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
How about searching for:Â sharepoint calculated column count weekdays
I’ll google around. Â It has something to do with assigning each day of the week a number value, i.e. Â Sunday = 1, Monday = 2. Â It then does some conditional calculating.
I have, but I’m afraid I don’t know what I’m googling for … everything tells me how to extract the weekdays, but I’m unable to find something that treats the number as a business day.
I’ve seen where someone has done a calculated column to do this. Â I can’t recall where it was. Â Have you tried googling for it?
