Count if week number matches date.

**DontTellMyMom** · 06-15-2020, 09:33 AM

Hi all.

I am trying to figure out how to count when date matches week number without a helper column.

I have a workbook 1 with week numbers in one column.

Edit: attached sample regular excel file

**DontTellMyMom** · 06-15-2020, 09:59 AM

EDIT:

fixed by self.
I used weeknum before, changed to isoweeknum and it works fine

=SUMPRODUCT(--(ISOWEEKNUM(DATA!$A$2:$A$10000) = A2))

maybe some1 can answer why did this happen?

**PeteABC123** · 06-15-2020, 10:03 AM

Nice job DontTellMyMom (self). Be sure to mark the thread as SOLVED under Thread Tools at the top of the page.

Pete
(I won't tell)

Count if week number matches date.

LinkBack

Thread Tools

Rate This Thread

Display

Count if week number matches date.

Re: Count if week number matches date.

Re: Count if week number matches date.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Updating week number, start date of the week, and year from a column date that's populated

Calculation of Week Number & Week Ending Date formula from a Year Cell

[SOLVED] Count Week numbers given start and finish week number

Receiving a date week by week depends on specific number?

[SOLVED] Appointing a number based on a date (to effectively create a round or week count)

week start date and end date based on week number

Calculating a Date Based on Year, Week Number and Day of the Week

Bookmarks

Bookmarks

Posting Permissions