Fiscal Week Dates

[ronaldbalza2023]

Hi everyone, how can I have a date with a week number that starts on Wednesday and ends on Tuesday of the following week. I am actually trying to mimic these calendar dates. Thanks in advance 😊

Financial Year 2022

Financial Year 2021

Financial Year 2020

[ddpl · Accepted solution]

Try this,...

Date Table =

     ADDCOLUMNS(

          CALENDARAUTO(6),

          "Month", FORMAT( [Date], "mmmm" ),

          "Week", WEEKNUM( EDATE( [Date], -6 ), 14 )

     )