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
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
Last edited by DontTellMyMom; 06-18-2020 at 05:46 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?
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks