1

I need to add a calculated column in SharePoint where I have to add +1 day from Monday to Thursday and +3 on Friday but I don't know how to do it. I did some tests with WEEKDAY without success.

  • can you create workflow for each item and apply login – Taha Zubair Jun 25 at 19:31
0

You can use WEEKDAY function like below:

=IF(WEEKDAY(Today())=2,Today()+1,Today())

This will check if today's day is "Monday", If Yes, it will add 1 days to today's date else it will set column value to today's date (Similarly you can add your other conditions to this formula).

Complete formula:

=IF(OR(WEEKDAY(Today())=2,WEEKDAY(Today())=3,WEEKDAY(Today())=4,WEEKDAY(Today())=5),Today()+1,IF(WEEKDAY(Today())=6,Today()+3,Today()))

Reference: WEEKDAY function

Note:

  1. This function returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default.
  2. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
  3. Return your calculated field as Date and Time.
| improve this answer | |
0

You could try the below formula:

=IF(OR(WEEKDAY([date])=2,WEEKDAY([date])=3,WEEKDAY([date])=4,WEEKDAY([date])=5),[date]+1,IF(WEEKDAY([date])=6,[date]+3,[date]))

enter image description here

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.