How to calculate vacation balance, not including weekends and holidays

Like (1) Share

Report

Posted on 10 May 2022 13:36:14 by daria_227

Hello dear Colleagues!

Currently I'm working on leave management flow for a company.

And I'm struggling with such issue: how to calculate vacation balance, not including weekends and holidays?

I would like that users will choose a date from/to of their vacation and power automate could calculate vacation balance not including weekends and holidays. I hope that I've described the idea correctly.

Maybe someone have done already smth similar?

Thank you!

I have the same question (0)

All responses (1)

Answers (0)

abm abm 32,506 Most Valuable Professional on 10 May 2022 at 13:46:16

Like (0)

Report

Re: How to calculate vacation balance, not including weekends and holidays

Hi @daria_227

To find the day of the week there is an expression called dayofWeek() which returns value between 1 to 7

Monday 1, Tuesday 2,.... Sunday 7

Expression I used above is dayofWeek(utcNow()). This will return todays day of the week. If you want to pass another date to check then pass the date instead of utcNow() function. See below.

dayofWeek('2022-10-12')

To find the other holidays you need to store those dates for the relevant year in SharePoint or Excel or some database. Query the data source with the date you want to check.

Thanks

Was this reply helpful? Yes No