View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CaptainQuattro
 
Posts: n/a
Default IF statement with Weekends vs. weekdays


OK. I learned something.

The optional parameter ,2 changes the day numbers to 1 for Monday
through 7 for Sunday.

You can also use parameter ,3 which makes Monday 0, and Sunday 6


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=539612