A
Alexball
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
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