Is it possible to write a formula that scans leave dates and locates the first day of leave (Mon - Fri) and the last day of leave considering public holidays and omitting weekends, from a list of dates?
I understand the NETWORKDAYS formula but am unable to figure out the logic to do this.
I understand the NETWORKDAYS formula but am unable to figure out the logic to do this.