Here's the problem!
I have 4 date ranges: 1. beginning of the month until today's date
2. beginning of the previous month until today's date of last month.
3. previous month..
4. previous month..
I got this part figured out. Now we have different business days between the starting dates and endind dates. I need to update these days so I will have the same number of business days in all 4 month.
there might be 10, 10, 10 and 9 business days. so we need to either update the dates on the month where we have 9 business days to 10 or update the days where we have 10 to 9. we cannot minimize 1 or add 1 for example because we could have a weekend.
any help would be appreciated...Thank u
Bookmarks