I know it is not directly related but sharepoint and excel are similiar:
I am trying to create a calculated column (Adjusted Date) that will add one day to [Date Received] if a sample is received on/after 12:00PM and on a Monday thru Thursday. add three days to [Date Received] if a sample is received on/after 12:00PM and on a Friday. Is the formula below close? Thank you.
=IF(AND([Time Received]>=12:00PM,[Day Received]<4),[Date Received] +1), =IF(AND([Time Received]>=12:00PM,[Day Received]=5),[Date Received] +3).
Thank you.
Bookmarks