0

One user wants to have a column, which will be a Date 30 days forward, but when if it falls on a weekend or holiday, it has to be after that. For example, today is 11/25, so after 30 days, it will be 12/25, so it should be 12/27. In the column. I know the function WORKDAY exists, but it counts only just workdays, not every day...

I try to use order of holiday days with function WEEKDAY and IF, but the function is very very long. In MS Excel, there can I use COUNTIF, but in SP I don't know how.

0

Here is my solution. I'm from Czech Republic, so there is our holiday's and for easterday now it calculates to year 2022.

=if(or(text(date+30,"d.m.")="1.1.",text(date+30,"d.m.yyyy")="17.4.2017",text(date+30,"d.m.yyyy")="2.4.2018",text(date+30,"d.m.yyyy")="22.4.2019",text(date+30,"d.m.yyyy")="13.4.2020",text(date+30,"d.m.yyyy")="5.4.2021",text(date+30,"d.m.yyyy")="18.4.2022",text(date+30,"d.m.")="1.5.",text(date+30,"d.m.")="8.5.",text(date+30,"d.m.")="6.7.",text(date+30,"d.m.")="28.9.",text(date+30,"d.m.")="28.10.",text(date+30,"d.m.")="17.11.",text(date+30,"d.m.")="26.12."),if(weekday(date+31,2)=6,date+33,if(weekday(date+31,2)=7,date+32,date+31)),if(or(text(date+30,"d.m.")="5.7.",text(date+30,"d.m.")="25.12."),if(weekday(date+32,2)=6,date+34,if(weekday(date+32,2)=7,date+33,date+32)),if(text(date+30,"d.m.")="24.12.",if(weekday(date+33,2)=6,date+35,if(weekday(date+33,2)=7,date+34,date+33)),if(or(text(date+30,"d.m.yyyy")="14.4.2017",text(date+30,"d.m.yyyy")="30.3.2018",text(date+30,"d.m.yyyy")="19.4.2019",text(date+30,"d.m.yyyy")="10.4.2020",text(date+30,"d.m.yyyy")="2.4.2020",text(date+30,"d.m.yyyy")="15.4.2022"),date+34,if(weekday(date+30,2)=6,date+32,if(weekday(date+30,2)=7,date+31,date+30))))))

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.