Hi All,
Please help me with this very tricky formula to find day count with respect to following condition.
Mon - 1
Tue - 1
Wed - 1
Thu - 1
Fri - 3
except for the below condition.,
- If a month is starting on Saturday or Sunday, then immediate Monday should be a correct business date. If a month is starting with Saturday, then immediate Monday should have 3 day counts and if a month is starting with Sunday, then immediate Monday should have 2-day counts.
- If a month-end day is Friday, subsequent Saturday and Friday should flow in next month and number of day counts should be 1 for that Friday.
| Date | Day | Day count | Explanation |
| 2024-08-01 | Thursday | 1 | Usually Monday to Thursday have day count as 1 and Friday have 3 |
| 2024-08-02 | Friday | 3 |
| 2024-08-05 | Monday | 1 |
| 2024-08-06 | Tuesday | 1 |
| 2024-08-07 | Wednesday | 1 |
| 2024-08-08 | Thursday | 1 |
| 2024-08-09 | Friday | 3 |
| 2024-08-12 | Monday | 1 |
| 2024-08-13 | Tuesday | 1 |
| 2024-08-14 | Wednesday | 1 |
| 2024-08-15 | Thursday | 1 |
| 2024-08-16 | Friday | 3 |
| 2024-08-19 | Monday | 1 |
| 2024-08-20 | Tuesday | 1 |
| 2024-08-21 | Wednesday | 1 |
| 2024-08-22 | Thursday | 1 |
| 2024-08-23 | Friday | 3 |
| 2024-08-26 | Monday | 1 |
| 2024-08-27 | Tuesday | 1 |
| 2024-08-28 | Wednesday | 1 |
| 2024-08-29 | Thursday | 1 |
| 2024-08-30 | Friday | 2 | If a month end falls on Friday and the subsequent Saturday falls on the same month, then Friday has day count as 2 |
| 2024-08-31 | Saturday | | |
| 2024-09-01 | Sunday | | |
| 2024-09-02 | Monday | 2 | Since Month is starting on Sunday, then Monday has day count as 2 |
| 2024-09-03 | Tuesday | 1 | |
