+ Reply to Thread
Results 1 to 3 of 3

count number occurring within specific date range

  1. #1
    Biff
    Guest

    Re: count number occurring within specific date range

    Read the post immediately below this one.

    Biff

    "Ducky" <Ducky@discussions.microsoft.com> wrote in message
    news:3EE14FB4-9146-4722-882E-E16C3C269105@microsoft.com...
    >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. #2
    Ducky
    Guest

    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

  3. #3
    Biff
    Guest

    Re: count number occurring within specific date range

    Read the post immediately below this one.

    Biff

    "Ducky" <Ducky@discussions.microsoft.com> wrote in message
    news:3EE14FB4-9146-4722-882E-E16C3C269105@microsoft.com...
    >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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1