How to calculate the business day of the month
I need to be able to calculate the business day of the month. I have tried the following formula:
Date_Time.Date.workday_seq - lookup( Date_Time.Date.workday_seq, Date_Time.Date.Date, $currentMonthStart ) + 1
This works if there are no holidays between the beginning of the month and the current date. This month, however, Memorial Day (US) causes the count to go off by 1 after 5/25. For example, today, 5/29 should be the 20th business day. The formula evaluates to 21st.
How can I adjust for intermediary holidays between the first of the month and the current date? (I am sure Anurag Malik has some ideas!)