Re: Count Mondays worked in Month

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


I guess let's just forget Holidays, I would like to count how many
Mondays, Tuesdays, Wednesdays, Thursdays, Fridays, Saturdays, & Sundays
worked based on the data below:

Here's my columns:
Date Day (calculated formula) Data

11/1 Mon xyz
11/1 Mon xyz
11/2 Tue xyz
11/3 Wed xyz
11/4 Thur xyz
11/7 Mon xyz
11/14 Mon xyz

X Mondays
X Tuedays
X Wednesdays, etc.


--
harnagel
------------------------------------------------------------------------
harnagel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29376
View this thread: http://www.excelforum.com/showthread.php?threadid=490858

.

Relevant Pages

  • Re: Count Mondays worked in Month
    ... HTH ... (remove nothere from the email address if mailing direct) ... > 11/1 Mon xyz ... > Holidays if possible). ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Count Mondays worked in Month
    ... Even if you didn't like my first attempt, you can still include holidays ... (remove nothere from the email address if mailing direct) ... > 11/1 Mon xyz ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Count Mondays worked in Month
    ... (remove nothere from the email address if mailing direct) ... > I guess let's just forget Holidays, I would like to count how many ... > 11/1 Mon xyz ...
    (microsoft.public.excel.worksheet.functions)
  • Count Mondays worked in Month
    ... Date Day (calculated formula) Data ... 11/1 Mon xyz ... harnagel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29376 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: I had the pre-made excel
    ... Happy Holidays ... honsbeek's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21150 ... Prev by Date: ...
    (microsoft.public.excel)