Par2: Calculating Fiscal Year 2003-04-04 -- Michael Ware I'm not sure what you're looking for, but if the year begins 6/1/yyyy then for any given date the start of the fiscal year should be: F_BOY = DATE(6,1,YEAR(DateVar)-Choose(DateVar < DATE(6,1,YEAR(DateVar)),1,0)) The week # of that date is then F_WeekNum = INT((DateVar-F_BOY)/7) That week starts at: F_WeekStart = F_BOY+F_WeekNum*7 And ends on: F_WeekEnd = F_WeekStart + 6 Printed April 28, 2024, 11:20 pm This article has been viewed/printed 35110 times. |