Good Afternoon,
I need help coming up with a formula that will return FISCAL WEEK based on the US Government Fiscal Year. US Government Fiscal Years run from Oct 1 - Sep 30. Moreover, the weeks run from Sunday (start) to Saturday (end). I have found a variety of formulas (such as the below) on various forums but none of them work for me. The main problem is that I cant get the formulas to see Sunday-Saturday as a week. Instead all the formulas I try run from Monday-Sunday. Please help. I am desperate! I know there is probably a simple answer but I am missing it.
Thank you,
Christina
=INT((A1-WEEKDAY(A1+1)-DATE(YEAR(A1)-(MONTH(A1)<10),10,1))/7)+2
Bookmarks