How to find yearly dates for weekdays

Hello

Originally Posted by bebo021999

In A3:
=DATE(A1,1,1)+CHOOSE(WEEKDAY(DATE(A1,1,1)),0,6,5,4,3,2,1)
A4 then copy down:
=A3+7

Format as you like in format cell/custom

This formula finds all the Sundays with dates for a year. How to find other days i.e Fridays for the year?


Best Regards
Imran Bhatti