Hi there,

I have two cells, B7 and C7, they are date formatted.

If both B7 and C7 are blank I need to return 0 (zero)

If, however, B7 has a value, but C7 is blank, I need to insert a value of .5

If both B7 and C7 have values I need to perfom the calculation "=NETWORKDAYS(B7,C7,Summary_page!$B$4:$B$11)"

I know I can use "=IF(ISBLANK" to return 0 (zero) when both B7 and C7 are empty, but from there I'm not sure what to do next.

I must admit this has me a bit flummoxed anyone have any ideas or can point me in the right direction?

Thanks very much.

Kind regards,

Mel