My fiscal year begins October 1. During the 2010 fiscal year, when the formula encounters week ending 12/26/2009, the following formula returns 91 for the fiscal week while it returns the correct week number for all other weeks.
The week ending date is in the F column in short format: 12/26/09
SUM(53-(INT((F2-WEEKDAY(F2+1)-DATE(YEAR(F2+7-WEEKDAY(F2+1))-(MONTH(F2)<10),10,1))/7)+2))
This only happens when the formula encounters this one week? Can anyone point me in the direction of a solution?
Bookmarks