Calculating Networkdays using IF and ISBLANK for HR Processes

[i_am_tommo]

Hi all

I am having difficulty to find the correct formula for my excel report.
I want to calculate the number of NETWORKDAYS from either; the start date of my process (AJ5) to the completion date (AR5) or the start date of my process (AJ5) to TODAY's date (for work in process lead time)

I am currently using this formula:

=IF(ISBLANK(AR5),NETWORKDAYS(AJ5,TODAY()),NETWORKDAYS(AJ5,AR5))

This working fine for me, except for the cells where there has been no start date for the process (in other words, AJ5 is blank) ---> I have huge numbers like 30,322 returned.

What I would like is a formula that calculates the NETWORKDAYS between AJ5 and AR5 or AJ5 and TODAY as above AND returns a blank value if there is no date in AJ5.

Thanks for your help in advance.

Tom

 

[RickXL]

Hi and welcome to the MrExcel Message Board.

Can you just add an:
=IF(ISBLANK(AJ5),"", ... ) around your existing formula?

=IF(ISBLANK(AJ5),"", IF(ISBLANK(AR5),NETWORKDAYS(AJ5,TODAY()),NETWORKDAYS(AJ5,AR5)))