Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting dates but excluding weekends | Excel Worksheet Functions | |||
Exclude weekends when counting days only on day 29 or 30 | Excel Worksheet Functions | |||
Weekends | Excel Worksheet Functions | |||
Subtact 2 dates to get the number without counting weekends? | Excel Worksheet Functions | |||
How to Calculate Dates without counting the weekends | Excel Worksheet Functions |