I am trying to count the number of days between two different dates. I would like to know the number of WORKDAYS (excluding weekends) between column H and I. But, IF column H is blank I need it to calculate the number of WORKDAYS between the dates in G and I. Result to display in column J.
The function NetWorkdays counts the work days between dates and also takes into account a list of public holidays that you can have somewhere in the workbook.
Wrap in an IF statement for different scenarios.