hi all my new at this. I am having a problem with an sumproduct iam trying to find out how may Saturday a list of dates. Sunday to Friday are working fine with is =SUMPRODUCT(--(WEEKDAY(A4:A300)=1)) for Sunday =SUMPRODUCT(--(WEEKDAY(A4:A300)=2) for Monday =SUMPRODUCT(--(WEEKDAY(A4:A300)=3)) for Tuesday =SUMPRODUCT(--(WEEKDAY(A4:A300)=4)) for Wednesday =SUMPRODUCT(--(WEEKDAY(A4:A300)=5)) for Thursday and =SUMPRODUCT(--(WEEKDAY(A4:A300)=2)) for Friday but when I use =SUMPRODUCT(--(WEEKDAY(A4:A300)=7)) for Saturday it give me an odd number the columns formatted as a date. if any one knows a different formula I can use.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sumproduct weekday
- Thread starter Hayward
- Start date
-
- Tags
- sumproduct formula
Brian from Maui
MrExcel MVP
- Joined
- Feb 16, 2002
- Messages
- 8,459
Upvote
0
bstory84
Active Member
- Joined
- Oct 31, 2011
- Messages
- 476
- Office Version
- 365
- Platform
- Windows
Weekday will by default return a 7 for a Cell with no value this is because the Date serial o(zero) return date 1-0-1900(Saturday). Blank cells are considered to have a value of zero by the formula.
Do you have Blank Cells In a the range?
Do you have Blank Cells In a the range?
Upvote
0
Similar threads
- Solved
