Thanks Phuocam.
I did a test with Start Date 10 Nov 2016, End Date 1 Dec 2016, and it returned Days Remaining = 16, which is correct but I need it to only return workdays or weekdays. It needs to not count Saturdays and Sundays. There are 6 weekend days between 10 Nov and 01 Dec, so the true number of workdays it should return should be 10.
So it has to it has to also subtract weekends and holidays. The holidays are derived from a list I put together.
Can you help?![]()
Bookmarks