How do I set an automatic working days counter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Selekeng - 01 Mar 2007 09:26 GMT

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.

Reply to this Message

Mike - 01 Mar 2007 10:26 GMT

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

> 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.

Reply to this Message

mr tom - 08 Mar 2007 15:28 GMT

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.

> With a start date for your project in A2
>
[quoted text clipped - 12 lines]
> > be updated automatically. I want to use this automatic counter to track
> > projects, to check how many days does the project has or left.

Reply to this Message