Date formula which only counts Workdays

[McCaughley7]

Hi All

I need a formula which calculates a "target ship date" based on an "order placed date" and set "timeline"

Cell B3 is my shipping reference
Cell I3 is my Order placed date
Cell H3 is the Agreed Timeline (Please note this cell is already populated with a number)

I am currently using the following which has been writted in Cell J3 =IF(B3="","",(I3+H3)) It works apart from the fact that it does not discount weekends which I need it to do.

Thanks for having a look

[BadlySpelledBuoy]

Please Login or Register  to view this content.

BSB

[Phuocam]

Try this ...

=IF(B3="","",WORKDAY(I3,H3))

[McCaughley7]

Thank you so much, I can see now where I went wrong.

Thanks

[Phuocam]

You are welcome!

[BadlySpelledBuoy]

Happy to help. Thanks for the rep point

BSB