Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working days in MS Query
I need to calculate NETWORKDAYS which works fine in Excel but I need to do it
in MS Query. Is there a formula? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working days in MS Query
See if this helps....
This MS Query SQL returns: The count of workdays (mon thru fri) by Name from the tblDatesNames table where dates are between 01-JAN-2008 and 25-JAN-2008 SELECT tblDatesNames.Name, Count(tblDatesNames.Date) FROM `C:\Sandbox1`.tblDatesNames tblDatesNames WHERE (weekday(Date) Between 2 And 6) AND (tblDatesNames.Date Between cdate('01-JAN-2008') And cdate('25-JAN-2008')) GROUP BY tblDatesNames.Name The returned values list looks like this: Name Expr1001 Alpha 4 Bravo 4 Charlie 4 Delta 4 Echo 2 Golf 2 Hotel 4 India 4 Juliet 4 Kilo 4 Lima 2 Is that something you can work with? Post back if you have more questions. Regards, Ron Microsoft MVP - Excel "mcquam" wrote in message ... I need to calculate NETWORKDAYS which works fine in Excel but I need to do it in MS Query. Is there a formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making weekend days working days - the system cuts the working tim | Excel Discussion (Misc queries) | |||
How to calculation no. of days (only working days) between two dat | Excel Discussion (Misc queries) | |||
Non working days | Excel Discussion (Misc queries) | |||
Working days | Excel Discussion (Misc queries) | |||
Working Days | Excel Discussion (Misc queries) |