I would like to know if there is a better way to define a SalesWeek that begines on Thursday and ends on the following Friday and then align it to my Financial Year (April - March) such that the first SalesWeek starts on the first Thursday of April, this becoming my 'FinSalesWeek'.
I have managed to define the SalesWeek as: Right(WeekName(D,0,-3),2) as SalesWeek, my challenge is to allign this SalesWeek to my financial year as defined above to come up with a FinSalesWeek.
As a short term solution i have defined my calendar in excel (see attached), but it complicates things when i want to pick things like the max event by date etc.
