| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Date Ranges
I have an Excel spreadsheet in which we use to keep track of online courses
we work on each semester at work. So far, I've been able to use the COUNTIF function to calculate the number of hours it takes to work on a course using a drop-down list that I've created. I would like to add some additional data to my "Reports" tab that would calculate the number of courses that we work on for a specific date range (example: from January 1, 2007 to March 15, 2007). Further, is there also a way to tally this information if I have multiple tabs on my spreadsheet that contain similar data? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating the number of values between specified ranges | Excel Discussion (Misc queries) | |||
| Calculating rate based on age ranges | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| Calculating with named ranges | Excel Discussion (Misc queries) | |||
| calculating date time ranges | Excel Worksheet Functions | |||
Threaded Mode
