How do I set an automatic working days counter
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
"Selekeng" wrote:
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.
|