Results 1 to 4 of 4

Count number of cells that fall within a range of dates

Threaded View

  1. #1
    Registered User
    Join Date
    07-22-2005
    Posts
    5

    Count number of cells that fall within a range of dates

    I am creating a log that keeps track of how many of a certain product are sold within the month. The product is always sold one at a time, so i just need a formula that can will look at the date column and report how many entries fall within the given month. The date is entered in the following format: mm/dd/yy. I have tried using the COUNTIF function:

    =COUNTIF(log!A2:log!A3000, CRITERIA)

    However, I do not know how to set up the CRITERIA to calculate all dates within a month, since the dates are not entered just as month and year, but include the day.
    Attached Files Attached Files

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