Formula to display Dates of every Friday's and Sunday's in a year as list in xl sheet? Could someone please advise ?

CodePudding user response：

=TEXT(DATE($A$1,1,1)-MOD(WEEKDAY(DATE($A$1,1,1)),{5,7}) 1 7*ROWS($1:1),"yyyy-mm-dd ddd")

Where A1 holds the year. This spills the result of Friday (5) and Sunday (7) next to each other (Office 365). Copy down.