Forum Discussion

ronaldbalza2023's avatar
ronaldbalza2023
Continued Contributor
4 years ago
Solved

Fiscal Week Dates

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

 

 

 

 

Show and Tell
Tips and Tricks
  • ddpl's avatar
    ddpl
    4 years ago

    Try this,...

     

    Date Table =
         ADDCOLUMNS(
              CALENDARAUTO(6),
              "Month", FORMAT( [Date], "mmmm" ),
              "Week", WEEKNUM( EDATE( [Date], -6 ), 14 )
         )

1 Reply

  • ddpl's avatar
    ddpl
    Solution Sage
    4 years ago

    Try this,...

     

    Date Table =
         ADDCOLUMNS(
              CALENDARAUTO(6),
              "Month", FORMAT( [Date], "mmmm" ),
              "Week", WEEKNUM( EDATE( [Date], -6 ), 14 )
         )