View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I change from a 7 day week to a 5 day week in Excel?

There are a couple of functions that need the analysis toolpak addin installed
(tools|addins).

Look at help for
=workday()
and
=networkdays()



mozzer10 wrote:

I am trying to set up a deadline set up in Excel but it shouldnt include the
weekends, for instance I want events that shoudl be completed within 2 days
and that are started on friday to be shown to be completed on monday rather
than on saturday. how can I do this?


--

Dave Peterson