SOLVED

** HELP ** Need help to calculate workdays between two dates

Copper Contributor

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.

 

sruk89_0-1695119120909.png

 

 

Any help greatly appreciated.

 

Regards,

 

Scott

 

1 Reply
best response confirmed by sruk89 (Copper Contributor)
Solution

image.png

The function you need is NETWORKDAYS

1 best response

Accepted Solutions
best response confirmed by sruk89 (Copper Contributor)
Solution

image.png

The function you need is NETWORKDAYS

View solution in original post