Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Phew, I keep coming across things I don't know how to resolve. A
spreadsheet I set up for holiday leave last week works great but I just realized that we need to know not just the number of days between a start and end date, but also the # of business days. The code for calendar days was easy, since it's just a subtraction formula, basically. i.e., between 7/28/2004 and 8/13/2004, there are 16 calendar days. By counting manually on paper calendars, I see that there are 12 business days between those 2 dates, if I've counted correctly. How would one code that in a formula, though, pls? Thank you! Where would I be without this fabulous ng and all you great MVPs and other out there! :oD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating the days between two dates | Excel Worksheet Functions | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
Calculating days between two dates | Excel Discussion (Misc queries) | |||
Calculating Days Between Dates | New Users to Excel | |||
Number of days between dates (Calendar) | Excel Programming |