Calculating countdown days left excluding weekends

[Noah101]

I have a date a file was received in one column then in another I have a if statement that says if its complete countdown 30 days from the time the file was received but minus weekends.

Your help appreciated , thank you!

 

[steve the fish]

See if this works:

=NETWORKDAYS(TODAY(),WORKDAY(A1,30)-1)