Sep 19 2023 03:23 AM - edited Sep 19 2023 03:25 AM
Hi All,
I need help with calculating work days between two dates in Column/Cell AP8 I have a formula "=Today()" and in column/cell E8 I have a date which will return a date of when a migration is due to take place. The issue i have is that the formula in column/cell AH8 calculates total days between todays date and the migration date, I need it to calculate work days only.
Any help greatly appreciated.
Regards,
Scott
Sep 19 2023 03:31 AM
SolutionThe function you need is NETWORKDAYS
Sep 19 2023 03:31 AM
Solution