IF WORKDAY Formula - where to add WORKDAY?

Hi All

I have written the formula below to calculate the difference between 2 dates in G12 and H12. It also calculates the difference between dates in S1 and G12 if H12 is empty.

I only want to count WORKDAYs but I am unable how to structure the formula. Have tried a few things but can't get it.

=IF(G12="","",IF(H12="",$S$1-G12,H12-G12))

Any help greatly appreciated.

Thanks
Greg

You need to use the NETWORKDAYS function, so try this:

=IF(G12="","",IF(H12="",NETWORKDAYS(G12,$S$1),NETWORKDAYS(G12,H12)))

Note that the start date comes before the end date in the parameter list. You can also take account of any holidays that are scheduled.

Hope this helps.

Pete

Here is a more compact version:

=IF(G12="","",NETWORKDAYS(G12,IF(H12="",$S$1,H12)))