View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default how to change week-offs from saturday and sundays to sunday and mo

Ima working in an Indain company. In our company we have week offs of
Sunday and monday. The networkdays( ) function counts only saturday and
sundays as week offs. But I need to change this default days to my
customized days.

Does any one suggest me how to change the week-offs in Excel.


Would the NETWORKDAYS function work as you want if you subtracted one from
all dates passed into it?

Rick