i know i can use Networkdays to calculate the workings days between two dates but need to be able to populate the number of working days for each month between two date ranges e.g absent between 01/04/2014 and 30/06/2014
so similar to the total days formula from this thread that puts total days into each monthly column i am looking for it to work the same way but populate each month with the number of working days between two dates.
MODERATOR's NOTE: This post was removed from another thread here to a thread of its own as per forum rules. Please be sure to review and follow the rules we all abide. Thanks.
Bookmarks