View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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.