| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count number occurring within specific date range
I need to count the number of sales that have occurred within a specific date
range. I have a worksheet showing a list of house sales with the sale dates. I have another worksheet showing a week beginning date and a week ending date. I want to know how many sales occurred between the week beginning and week ending date by using the week beginning and ending dates in the formula. My countif formula works if I type the beginning and ending dates in the formula but not if I link to the cells. I am using Microsoft Excel 2003 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count number occurring within specific date range
Read the post immediately below this one.
Biff "Ducky" wrote in message ... I need to count the number of sales that have occurred within a specific date range. I have a worksheet showing a list of house sales with the sale dates. I have another worksheet showing a week beginning date and a week ending date. I want to know how many sales occurred between the week beginning and week ending date by using the week beginning and ending dates in the formula. My countif formula works if I type the beginning and ending dates in the formula but not if I link to the cells. I am using Microsoft Excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find total number workdays from a range of date | Excel Worksheet Functions | |||
| Countif for the number of a specific count? | Excel Worksheet Functions | |||
| formula to count cells containing #'s in a specific range | Excel Worksheet Functions | |||
| How do I stop Excel interpretting a number range as a date? | Excel Discussion (Misc queries) | |||
| count records in a date range | Excel Discussion (Misc queries) | |||
Linear Mode
