Very tricky date formula

[sam.tidswell-norrish]

If I have column G (1000 rows) with start dates, and column AT (also 1000 rows) with completion dates, but not all of column AT is complete, what formula do I use to show how many WORKING DAYS (ie 5 per week) the action took?

I presume it must begin with an IF statement as it hinges upon IF there is a date in column AT...?


Please help!

 

[sam.tidswell-norrish]

Anyone?

 

[SteveO59L]

=if(at1="","",networkdays(g1,at1))

 

[VoG]

Duplicate http://www.mrexcel.com/forum/showthread.php?t=559314