How to find yearly dates for weekdays

Try for Friday:

=DATE(A2,1,1)+CHOOSE(WEEKDAY(DATE(A2,1,1)),5,4,3,2,1,0,6)

Rule for the list of CHOOSE function:
Sunday: starts with 0
Monday: starts with 1
...
Fri: starts with 5

So the logic is in the CHOOSE section

which ever day we want we should start the set from that day serial?

Originally Posted by ImranBhatti

So the logic is in the CHOOSE section

which ever day we want we should start the set from that day serial?

the list is :
0,6,5,4,3,2,1 for Sun

For the next day, the last one to be the first one

1,0,6,5,4,3,2 for Mon

2,1,0,6,5,4,3 for Tue

...

5,4,3,2,1,0,6 for Fri...

Nice magic of digits.

Thanks a lot.