Hello,

I have created a calendar by dragging down dates (one whole year).
Using various formulas I have managed to distinguish if a day is a
workday “WD”, weekend “WE” or Holiday “HD”.
So next to each date “WD”, “WE” or “HD” is written.

Now I want to count WDs from date 12-06-2006 to 23-11-2006. I want to
count actual workdays for calculation. The dates are in column A the
day type in column B.

A -------B

Date1 WD
Date2 WE
…

I have tried various things but without success. Any suggestions?

Thanks a lot.

Alex


--
Alexball
------------------------------------------------------------------------
Alexball's Profile: http://www.excelforum.com/member.php...o&userid=37072
View this thread: http://www.excelforum.com/showthread...hreadid=567930

Check the help for the DCOUNT function. It comes with examples that may help
you in adapting it to your needs.

Hope this helps,
Miguel.

"Alexball" wrote:


Hello,

I have created a calendar by dragging down dates (one whole year).
Using various formulas I have managed to distinguish if a day is a
workday €œWD€�, weekend €œWE€� or Holiday €œHD€�.
So next to each date €œWD€�, €œWE€� or €œHD€� is written.

Now I want to count WDs from date 12-06-2006 to 23-11-2006. I want to
count actual workdays for calculation. The dates are in column A the
day type in column B.

A -------B

Date1 WD
Date2 WE
€¦

I have tried various things but without success. Any suggestions?

Thanks a lot.

Alex


--
Alexball
------------------------------------------------------------------------
Alexball's Profile: http://www.excelforum.com/member.php...o&userid=37072
View this thread: http://www.excelforum.com/showthread...hreadid=567930

Hi Alexball,

here a way

=sumproduct(--(indirect("B"&match(date(2006,06,12),A:A)&":"&("b" &match(date(2006,11,23),A:A))="WD"))

you also could use
=sumproduct(--(indirect("B"&match(c1,A:A)&":"&("b"&match(c2,A:A) )="WD"))

replacing the date function for c1 and c2

hth
regards from Brazil
Marcelo




"Alexball" escreveu:


Hello,

I have created a calendar by dragging down dates (one whole year).
Using various formulas I have managed to distinguish if a day is a
workday €œWD€�, weekend €œWE€� or Holiday €œHD€�.
So next to each date €œWD€�, €œWE€� or €œHD€� is written.

Now I want to count WDs from date 12-06-2006 to 23-11-2006. I want to
count actual workdays for calculation. The dates are in column A the
day type in column B.

A -------B

Date1 WD
Date2 WE
€¦

I have tried various things but without success. Any suggestions?

Thanks a lot.

Alex


--
Alexball
------------------------------------------------------------------------
Alexball's Profile: http://www.excelforum.com/member.php...o&userid=37072
View this thread: http://www.excelforum.com/showthread...hreadid=567930