Hi guys. I have two cells with different dates - E2 and H2. I want to know the network days between the two but also want the result to show:
- as blank if E2 is left blank
And/or
- Using todays date if H2 is left blank.
So far I have -
=NETWORKDAYS (E2,(IF(H2='''',TODAY(),H2))
Any idea how i add in if E2 is left blank then theres no result also?
Many thanks