Working Days & Counting days

[Riviera*]

I have the following formulae which counts all the days between a certain date (D2) & today. I would like to count all the working days between a date & today, thus giving me the number of days I have left to complete a task.

=IF(B2<>"",D2-TODAY(),"")

Thanks.

RiV*

 

[Gettingbetter]

=networkdays(firstdate,seconddate)

(Make sure you have the 'Analysis Toolpak' options Ticked in your add in list)

Cheers