Hi,
I have been searching the internet to find a custom function for Power Query that will calculate networkdays in a decimal format, between two date columns, where either date may be formatted as either date or datetime. I have only found solutions which require the dates to be formatted as date, and none which work with datetime. The function should be able to exclude weekends and holidays according to a custom table.
Does anybody know of a workable solution for this?
Regards,
Marbleking
Bookmarks