Chris Colson

Chris Colson

  • 2k
  • 7
  • 130

Calculating the next business day after holiday and/or weekend

Jul 28 2020 12:51 PM
Has anyone used Power Apps to calculate the day after a holiday and/or weekend? I am looking for a way to automatically calculate the next available business day. If a deadline for a project is Thursday and Friday is a holiday and then the weekend, the next available business day would be the following Monday. Is there a way to calculate this?
 
I have seen Power App presentations on calculating total number of days, excluding holidays and weekends, but this is different. I want to be able to have the Power App calculate the next available business day.
 
Thanks in advance.  

Brought to you by:

Answers (2)