How do I set an automatic working days counter

[Selekeng]

I need to set an automatic working days (Mon to Fri) counter so the date can
be updated automatically. I want to use this automatic counter to track
projects, to check how many days does the project has or left.

 

[Mike]

With a start date for your project in A2

=NETWORKDAYS(A2,NOW())

will return how many weekdays your project has been running for.

With the planned end date in B2

=NETWORKDAYS(NOW(),B2)

Will return the number of days remaining. Note that this last formula will
go negative if your project overruns

 

[mr tom]

You can also expand that to not count bank holidays etc by including a list
of dates which you're not working for - Forumlas as below, but add a comma
and then a reference to the range including the dates, e.g:

A5 25/12/2007
A6 26/12/2007
A7 01/01/2008

=NETWORKDAYS(A2,NOW(),A5:A7)

Hope this helps.

Tom.