It worked.Thank you very much.

Am Wed, 31 Dec 2014 17:17:38 +0000 schrieb GRS6411:

I am using =NETWORKDAYS(A2,B2) for days open
How can i modify the above formula so it will pickup Todays's date if
there is no date in B5.

in C2 try:

=NETWORKDAYS(A2,IF(B2=0,TODAY(),B2))
and copy down


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional[/quote]