Results 1 to 10 of 10

Counting Dates that fall within a certain month

Threaded View

  1. #1
    Registered User
    Join Date
    06-19-2008
    Posts
    63

    Counting Dates that fall within a certain month

    Please open the xls. file I've attached to help understand me problem.

    I have items arriving on certain dates (the dates are listed in column N)

    In the cell to the right of each month, I want to have a formula that will count the dated cells in column N that fall under each month.

    i.e. In cell B5, next to January, I want to display the total number of cells that contain a date in January (ultimately giving me the number of items that arrive in January) the number would read '5' because there are 5 dates in January that are in the list.

    How can I accomplish this?
    Attached Files Attached Files
    Last edited by wnstar21; 01-23-2009 at 04:58 PM.

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