Switch Function

[josevaras]

Hello - how does one change the below to be able to use the Switch function? TIA

The goal is that for any day of the week, the date reverts to the most recent Friday. 

Data Thru =

IF( WEEKDAY(

TODAY() ) = 1 , TODAY() -2,

IF( WEEKDAY(

TODAY() ) = 2 , TODAY() -3,

IF( WEEKDAY(

TODAY() ) = 3 , TODAY() -4,

IF( WEEKDAY(

TODAY() ) = 4 , TODAY() -5,

IF( WEEKDAY(

TODAY() ) = 5 , TODAY() -6,

IF( WEEKDAY(

TODAY() ) = 6 , TODAY() -7,

IF( WEEKDAY(

TODAY() ) = 7 , TODAY() -8,

TODAY()

)

[Fowmy · Accepted solution]

@josevaras 

You can do it this way as well:

Data Thru = TODAY() -  WEEKDAY(TODAY(),16)

[josevaras]

Thanks for responding. Can you explain to me why type 16?

[Fowmy]

@josevaras 

It sets the week start day as Saturday, check the following table so the weekday gives number three by which the date is pushed back by three days.

[themistoklis]

@josevaras 

Try the following:

New Column = SWITCH(TRUE, WEEKDAY(TODAY() ) = 1 , TODAY() -2

                                                  WEEKDAY(TODAY() ) = 2 , TODAY() -3

                                                  WEEKDAY(TODAY() ) = 3 , TODAY() -4 ....., TODAY())