View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bluestone bluestone is offline
external usenet poster
 
Posts: 1
Default counting weekends

Hi-
I have a spreadsheet with 1st column being numerical dates of the
year. Second column contains initials of person on call for the
corresponding date. Same person is on call for Friday, Saturday, and
Sunday (weekend on call). I am unsuccessfully trying to write VB code
to calculate how many weekends (not the total days) each person (by
initials) is on call. (Spreadsheet has several yrs of dates, and
people complaining that they have more weekends of call than someone
else)

TIA

CLS