ryannordgren

- Posts
- 7
- Registration date
- Saturday March 4, 2017
- Last seen
- March 7, 2017

- Posts
- 7
- Registration date
- Saturday March 4, 2017
- Last seen
- March 7, 2017

Related:

- If cell contains any text
- Excel if cell contains any text - Best answers
- If cell contains any text then - Best answers
- How to find someone's location by cell phone number - How-To - Mobile
- If cell contains text then ✓ - Forum - Excel
- How to copy data from one cell to another in excel using formula - Forum - Office Software
- Excel if cell contains text then copy to another sheet ✓ - Forum - Excel
- Excel conditional formatting based on date in another cell - How-To - Excel

Best answer

Mazzaropi

- Posts
- 1834
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- May 30, 2018

Try to use:

Is that what you want?

I hope it helps.

--

Belo Horizonte,

Marcílio Lobão

A few words of thanks would be greatly appreciated. Add comment

has helped 2601 users this month

Report

ryannordgren

- Posts
- 7
- Registration date
- Saturday March 4, 2017
- Last seen
- March 7, 2017

Yes, Thank you! This works.

Report

ryannordgren

- Posts
- 7
- Registration date
- Saturday March 4, 2017
- Last seen
- March 7, 2017

One more question, if you have the time. I can get this to work now for each day of the week except for Saturday. Any idea how to get it to count Saturdays using this same formula?

Mazzaropi

- Posts
- 1834
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- May 30, 2018

"

Look at this:

WEEKDAY( Serial_number, Return_type)

The WEEKDAY function syntax has the following arguments:

A sequential number that represents the date of the day you are trying to find. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

A number that determines the type of return value.

then...

1 --> Monday

2 --> Tuesday

3 --> Wednesday

4 --> Thursday

5 --> Friday

6 --> Saturday

7 --> Sunday

In the suggested formula, we compare the number of the day of the week to the value

=SUMPRODUCT(--(WEEKDAY(A1:A30, 2)=

Simply replace these values to get the count for each day of the week you want.

I hope it helps.

--

Belo Horizonte,

Marcílio Lobão

A few words of thanks would be greatly appreciated. Add comment

has helped 2601 users this month

I appreciate your help. This formula:

=SUMPRODUCT(--(WEEKDAY(A1:A30, 2)= 1 ))

works for every day of the week except Saturday. For some reason when I enter the formula: =SUMPRODUCT(--(WEEKDAY(A3:A200, 2)= 6 )) - for Saturday, it shows the value "198" with no values in the A column!? For every date I add in the A column, it subtracts another 1 from the 198. For example if I add a date range comprising Sunday through Saturday - 7 lines - it will read "192."

The formulas counting for every other day of the week read "1" for this same formula. It just doesn't want to work for Saturday for some reason. I don't know why it is subtracting when the same formula using every other day of the week (1,2,3,4,5,7) works correctly, adding a value of 1.

Any ideas friend?

=SUMPRODUCT(--(WEEKDAY(A1:A30, 2)= 1 ))

works for every day of the week except Saturday. For some reason when I enter the formula: =SUMPRODUCT(--(WEEKDAY(A3:A200, 2)= 6 )) - for Saturday, it shows the value "198" with no values in the A column!? For every date I add in the A column, it subtracts another 1 from the 198. For example if I add a date range comprising Sunday through Saturday - 7 lines - it will read "192."

The formulas counting for every other day of the week read "1" for this same formula. It just doesn't want to work for Saturday for some reason. I don't know why it is subtracting when the same formula using every other day of the week (1,2,3,4,5,7) works correctly, adding a value of 1.

Any ideas friend?

Try this one. It checks for a blank in the cell.

=SUMPRODUCT(--(A3:A200<>""),--(WEEKDAY(A3:A200,2)=6))

This issue of blanks being interpreted as Saturdays has been around for a years now.

=SUMPRODUCT(--(A3:A200<>""),--(WEEKDAY(A3:A200,2)=6))

This issue of blanks being interpreted as Saturdays has been around for a years now.

ryannordgren
Mar 7, 2017 at 07:01 PM

- Posts
- 7
- Registration date
- Saturday March 4, 2017
- Last seen
- March 7, 2017

Most excellent! that works perfectly!