Formula IF Today() i a Friday then put date in full ie: Friday 3 November 2023, if Today is not a Friday, then put the previous Monday's date in full

[andycreber]

Hi All, I would like to write a formula: IF Today() is a Friday then put the date in full ie: Friday 3 November 2023, if Today is not a Friday, then put the previous Monday's date in full IE: Monday 30 October 2023

Happy for a helper column if easier to write formula

thanks all

 

[thespardian]

Suppose the date is in B1
=IF(WEEKDAY(B1)=6,B1,B1-WEEKDAY(B1,2)+1)

with today()
=IF(WEEKDAY(TODAY())=6,TODAY(),TODAY()-WEEKDAY(TODAY(),2)+1)

 

[Fluff]

Another option

=IF(WEEKDAY(TODAY(),2)=5,TODAY(),WORKDAY.INTL(TODAY()+1,-1,"0111111"))