+ Reply to Thread
Results 1 to 5 of 5

Count if cell range dates are equal to monday

  1. #1
    Registered User
    Join Date
    10-08-2014
    Location
    UK
    MS-Off Ver
    2013
    Posts
    19

    Count if cell range dates are equal to monday

    Hi,

    i'm looking to create a formula that counts the number of Mondays in a given cell range which contain a mixture of dates and empty cells ("").

    i have used =SUMPRODUCT((WEEKDAY(A11:A23)=2)*1) , but this doesn't seem to work with cells that are =""

    Any chance someone could help please.

    Thanks in advance
    Suban

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Count if cell range dates are equal to monday

    Try this
    =SUMPRODUCT(--(TEXT(A11:A23,"ddd")="mon")*1)

    Punnam

  3. #3
    Registered User
    Join Date
    10-08-2014
    Location
    UK
    MS-Off Ver
    2013
    Posts
    19

    Re: Count if cell range dates are equal to monday

    Hi Punnam,

    Thanks for that, it worked! If you get a chance could you please explain what the formula is doing so that i can correct any errors i might have.

    Thanks again

  4. #4
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Count if cell range dates are equal to monday

    HI

    Unless i see your working data it is difficult .
    Upload a sample work book with out any confidential data i shall check and explain you

    Punnam

  5. #5
    Registered User
    Join Date
    10-08-2014
    Location
    UK
    MS-Off Ver
    2013
    Posts
    19

    Re: Count if cell range dates are equal to monday

    Thank you for your help puinnam, just out of interest is there any way you could help with this post please

    http://www.excelforum.com/excel-form...ml#post3861843

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count full weeks Monday thru Sunday between 2 dates
    By Tony Valko in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 07-28-2014, 10:32 AM
  2. If Dates in range equal today then copy cell x
    By Greg420 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 15
    Last Post: 03-20-2014, 09:47 AM
  3. [SOLVED] Count cells in a range, starting from first cell with number that does not equal zero
    By ldoherty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2014, 10:06 AM
  4. Replies: 3
    Last Post: 12-12-2012, 12:30 PM
  5. Formula Count Entries in a range if another range is = 1 and Another = Monday
    By realniceguy5000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-29-2011, 02:10 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