In a query, what is the formula for subtracting two dates and find how many business days between the dates. Like - Daysbetween[enddate])-([startdate]) etc. I just want the business days, not the weekends.
Results 1 to 3 of 3
Thread: Subtract Dates (2000)
-
5 Star Lounger
- Join Date
- Jan 2001
- Posts
- 1,110
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2003-01-09 19:31Subtract Dates (2000)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Gold Lounger
- Join Date
- Jun 2001
- Location
- Crystal Beach, FL, Florida, USA
- Posts
- 3,306
- Thanks
- 1
- Thanked 11 Times in 11 Posts
2003-01-09 19:49Re: Subtract Dates (2000)
There is no formula, you have to create your own function. YOu might want to search previous posts, as this has been asked before.
Mark Liquorman
See my website for Tips & Downloads and for my Liquorman Utilities.
-
Platinum Lounger
- Join Date
- Dec 2001
- Location
- Melbourne, Australia
- Posts
- 4,399
- Thanks
- 0
- Thanked 13 Times in 13 Posts
2003-01-09 20:16Re: Subtract Dates (2000)
Try <post#=206659>post 206659</post#>
Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
