# How to count network days between two dates, using todays date where second date is blank?

1. ## How to count network days between two dates, using todays date where second date is blank?

Hi

I am looking to create a formula that will count the number of work days (network days) between two dates and to use today's date where the second is blank.

The intention is that I can show how old incidents are in the one cell, regardless of whether they are open or closed

Here's the layout for what i want to achieve:

Col A, Col B, Col C
Row 1, Open Date, Closed Date, No.Workdays Open
Row 2, 05-Mar-2012, 12-Mar-2012, 6
Row 3, 16-Mar-2012 , *, 2

*where today is the 19 March

So far I have worked out how to use Network Days
=NETWORKDAYS(A2,B2)

And how to use today's date where col B is blank
=IF(ISBLANK(B2),TODAY()-A2,B2-A2)

But I can't seem to combine the two.

Any suggestions greatly appreciated.

2. ## Re: How to count network days between two dates, using todays date where second date is bl

Try:

=NETWORKDAYS(A2,IF(B2="",TODAY(),B2))

3. ## Re: How to count network days between two dates, using todays date where second date is bl

=NETWORKDAYS(A2,IF(B2="",TODAY(),B2))

Dom

4. ## Re: How to count network days between two dates, using todays date where second date is bl

deleted - better solutions posted above...

5. ## Re: How to count network days between two dates, using todays date where second date is bl

hi phl8pg,

Welcome to the forum.

use the following formula:-

=NETWORKDAYS(A3,IF(ISBLANK(B3),TODAY(),B3))

Regards,
DILIPandey

<click on below 'star' if this helps>

6. ## Re: How to count network days between two dates, using todays date where second date is bl

=if(b2="",networkdays(a2,today()),networkdays(a2,b2))

7. ## Re: How to count network days between two dates, using todays date where second date is bl

To NBVC, dilipandey, Domski and darknation144

Thank you all so much for your advice, I've checked the three different solutions supplied and all result in identical, and correct, results.

I am in awe of you all.

Thanks also Icestationzbra for giving it a go...

regards, phl8pg

8. ## Re: How to count network days between two dates, using todays date where second date is bl

This was very helpful for 50% of the data I am trying to record.

9. ## Re: How to count network days between two dates, using todays date where second date is bl

you are welcome phl8pg,

Cheers

Regards,
DILIPandey
<click on below * if this helps>

There are currently 1 users browsing this thread. (0 members and 1 guests)