# Count if cell range dates are equal to monday

1. ## 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.

Suban

2. ## Re: Count if cell range dates are equal to monday

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

Punnam

3. ## 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. ## 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. ## 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

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