Hello

I'm trying to work out how long a process is taking at several stages at the point the spreadsheet opens.

Formula I have is below.

=NETWORKDAYS(G4,S4,'Bank Holidays'!A1:A387)-1

I need to add an IF formula to show that IF S4 is blank then use today's date. This is in Cell B1. If it isn't blank then just use the date in the field.

Played around and I'm getting a bit stuck.

Help is appreciated.

Thanks
Matt