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 November 21, 2024, 11:32 am This article has been viewed/printed 35204 times. |