Count working days but display custom text if end date is empty

[Rob_83]

Hi All,

This is probably a really easy one for my first post but my formula skills aren't perfect.

I'm looking to count working days between two dates (this part is easy - NETWORKDAYS)

BUT, if the end date is open/incomplete, I'd like my count box to display custom text instead of a huge minus number. I thought the below would work, but I am indeed getting a huge minus number instead of 'Ongoing':

=IFNA(NETWORKDAYS(B11,B12),"Ongoing")

Any help would be greatly appreciated. This place has helped me lot already but I couldn't seem to search for this particular scenario in this instance!

 

[FormR]

Hi, welcome to the board!

They'll be a few ways to do this, here is one option you can try..:

=IF(COUNT(B11:B12)=2,NETWORKDAYS(B11,B12),"On Going")

 

[Rob_83]

And there it is, that has done the job perfectly, thanks very much!