I'm a self-taught user, mostly learning from Professor Google. I used =WEEKNUM(P246)-WEEKNUM(DATE(2016,6,30),15) to show 7/1/2016 as week 1 of my fiscal year starting on Friday. When I copied the formula across the entire fiscal year, the week numbers went to a - negative number after week 27. Would you have a fix for that? Thanks