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?
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.