| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting between dates | Excel Worksheet Functions | |||
| Counting Dates | Excel Worksheet Functions | |||
| counting dates in a column that less than 6 months from today | Excel Discussion (Misc queries) | |||
| Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
| counting entries between two dates? | Excel Worksheet Functions | |||
Threaded Mode
