How to find yearly dates for weekdays

[ImranBhatti]

Hello

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

[bebo021999]

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

[ImranBhatti]

So the logic is in the CHOOSE section

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

[bebo021999]

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...

[ImranBhatti]

Nice magic of digits.

Thanks a lot.