Results 1 to 5 of 5

HELP count how many cells are in a specific week number per month

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2014
    Posts
    8

    Exclamation HELP count how many cells are in a specific week number per month

    Hello. Please help. I badly need to track the orders (or codes) that needed to be completed in the specified date. This is my Data looks like (sheet1 named "April." my date is horizontal instead of vertical):

    "refer to attached screenshot"

    In a separate sheet (sheet2 named "Summary"), I created the below table to gauge on how many codes are expected be completed in a specific week (based on the dates in sheet1:

    "refer to attached screenshot"

    I have Sheet3 (named "Sheet1") prepared as reference for the dates (column A) and their month number (column B) with the week number (slightly altered as I need exact week number of the month i.e. week 1, week2, week 3, week 4 or week 5 or the month of May):

    "refer to attached screenshot"

    What I want to do is get the date fom sheet1 for the expected completion dates and reference it with sheet 3 and count how many codes and record it in sheet 1.

    PLEASE PLEASE HELP. *sorry for the sheet naming :(
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] macro to copy specific columns and rows for a specific month and week
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2015, 11:23 AM
  2. Count number of cells in column per month, ignore blank cells
    By lamdl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-13-2014, 08:50 PM
  3. Replies: 2
    Last Post: 12-17-2013, 06:30 AM
  4. [SOLVED] Count the number cells > 0 for each day of the month.
    By Chanley24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-09-2013, 12:37 AM
  5. Receiving a date week by week depends on specific number?
    By ExcelBG in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2013, 10:20 AM
  6. Replies: 10
    Last Post: 01-22-2012, 10:05 AM
  7. Replies: 1
    Last Post: 03-05-2011, 04:18 PM

Tags for this Thread

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