Using Weekday and CountIf functions to count days in an array

**FlameRetired** · 09-14-2017, 03:00 AM

Try this in cell D2.

Formula:

=SUMPRODUCT(--(WEEKNUM(+Table1[DUE DATE],1)=WEEKNUM($B$1,1)),--(WEEKDAY(+Table1[DUE DATE],1)=6))

**Mongoloid** · 09-14-2017, 10:34 AM

Thanks Dave. That worked. Can you please explain what you did so that I can modify the formula for other lengths of time, or reconfigure to include weekends?

Using Weekday and CountIf functions to count days in an array

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Using Weekday and CountIf functions to count days in an array

Re: Using Weekday and CountIf functions to count days in an array

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] COUNTIF? (Count number of date values in a column more than 30 days old)

Help me! I want to count the working days of worker with count and if array.

[SOLVED] Consecutive Employee Vacation Days using sumif array with frequency and column functions

Array to count how many days within a range are greater than 5

Determining Count (combining countif and lookup functions?)

Countif with other functions -- Median, IF, Count

Countif to count if falls with in 90 days of todays date

[SOLVED] Help with Count, CountIf, Sum Functions

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions