#### Dummy Excel

##### Well-known Member

i have a formula which im trying to calculate a percentage based on historical data by week

Formula:

Code:

`=(Networks!$C$62-COUNTIFS(Historical!$A:$A,Q$16,Historical!$I:$I,WEEKNUM((TODAY())-P27)))/Networks!$C$62`

"WEEKNUM((TODAY())-P27)" becomes (43761-42) as P27=WEEKNUM(TODAY())-1) to get the previous week number

So the formula evaluates to 3719 which equals to wk 37 and not wk 42

HELP!

thanks

Sam