If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report that generates number of working days within two date range
Hello All
I suppose you may have been asked this question a million times, however I have a report that counts the number of days from a start date and end date. I have a query set up and a very basic formulae to count these days I.E. Date()-[DateOfStatus]. this counts the number of days from today and the date of status. I would like this query to only count working days (I.E. Monday to Friday) I have seen several posts requesting assistance with calculating working days and someone has replied with a lengthy code to place somewhere, however I am not sure that this is what I need to do the job. Can someone steer me in the right direction? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combo Box (1st) Populating Text Box (2nd) Field | AccessRookie | Using Forms | 1 | April 6th, 2005 11:37 PM |
Combo Box & Text Box | AccessRookie | Using Forms | 3 | April 6th, 2005 11:33 PM |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |
Number of working days between two dates | david | Worksheet Functions | 4 | June 15th, 2004 04:14 AM |
Number of working days between two dates | James Silverton | Worksheet Functions | 3 | October 23rd, 2003 12:40 PM |