Week Num

[Dummy Excel]

Hi All,
I have a formula which has nearly 2yrs worth of data

=WEEKNUM(TODAY())

issue i have is that means there are nearly 2 of every week. How can i determine in my formula to look at current year only?


thanks
Samuel

 

[PaddyD]

Details will depend but something along the lines of:

=year(today())=year(cell_with_a_date_in)

?

 

[Dummy Excel]

sorry i shouldve been a little clearer with my OP
i need the year and weeknumber to be incorporated for my formula
so my actual formula is;

=COUNTIFS(Historical!$A:$A,A9,Historical!$I:$I,WEEKNUM(TODAY())-1)

hope that makes more sense

 

[Fluff]

Which column on the "Historical" sheet contains the year or date?

 

[Dummy Excel]

column E in Historical has the date ie dd/mm/yyyy
thanks
Sam

 

[Fluff]

How about
=COUNTIFS(Historical!$A:$A,A9,Historical!$I:$I,WEEKNUM(TODAY())-1,Historical!$E:$E,">="&DATE(YEAR(TODAY()),1,1),Historical!$E:$E,"<="&DATE(YEAR(TODAY()),12,31))