Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to calculate the workday.
Example:
Calculate the Workday from 2016/02/01 ~ 2016/02/07
Now I have Workday database for weekend like below
My Expression : LastWorkDate(StartDay,4) But it does not include the day (2016/02/06)
How I could to write the expression? Many thanks.
Workday | Day |
2016/2/6 | Saturday |
2016/2/14 | Sunday |
2016/4/2 | Saturday |
2016/4/30 | Saturday |
2016/6/12 | Sunday |
2016/9/18 | Sunday |
2016/10/8 | Saturday |
2016/10/9 | Sunday |
2016/3/19 | Saturday |
= LastWorkDate('DayName',4)
Do want to calculate in the front end or in the script?
in the script
But the Workday on Saturday or Sunday could not be calculate.
Hi,
Check this link below and adjust the script accordingly
Master Calendar with Working days & Holidays Flag
Regards,
jagan.
Hi Jiadong,
Use this macro to calculate no of Saturday in the date range and then calculate the net working days. Hope it will help.