I've done some googling and can't find an easy-to-follow walkthrough on recreating a NETWORKDAYS functions using Power Query.
Does anybody have an idiot-proof step-by-step they could point me to?
Where I'm at.....
I have a Power Query query that contains a table of dates, one row for each date.
I have a second column which has a "Yes" if the date in that row is a public holiday.
I have a third column that uses a formula to give a day of the week from 0 to 6 for each date.
I have a fourth column that contains a 1 if the date is a Working Day, and a zero if it is not a Working Day.
The last step is I filter so only workday dates are included in the list.
That's where I'm stuck, trying to create the function to apply to my start and end date.
Bookmarks