ExcelBanter - Days open Calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Days open Calculation (https://www.excelbanter.com/excel-discussion-misc-queries/450553-days-open-calculation.html)

GRS6411

Days open Calculation

1 Attachment(s)

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.
Can anybody help ASAP with that.........

Claus Busch

Days open Calculation

Hi,

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

GRS6411

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]

All times are GMT +1. The time now is 05:44 AM.