Counting workdays between dates
 

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

Counting workdays between dates
 

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

Counting workdays between dates
 

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