Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
96
Views
Topic starter
I hope this will be a interesting challenge. Which could be the formulas from C2 to N8 to obtain years -separated by comma- that have the same days of the week distribution in their months. For instance, in C2 should appear: 1978, 1984, 1989, 1995
| YEAR I | JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER | |
| 1970 | 1 on Sunday | ||||||||||||
| YEAR F | 1 on Monday | ||||||||||||
| 2000 | 1 on Tuesday | ||||||||||||
| 1 on Wednesday | |||||||||||||
| 1 on Thursday | |||||||||||||
| 1 on Friday | |||||||||||||
| 1 on Saturday |
Posted : 19/10/2021 6:38 am
Interesting challenge, indeed, but not clear unfortunately. Where are those years coming from? (1978, 1984, 1989, 1995)
that have the same days of the week distribution in their months
Column names are month names, not dates, how do you suggest to find the days of the week in a text string? We should just identify all Mondays from example, for that specific month name?
Please provide a more clear sample file, you can attach it here.
Posted : 20/10/2021 7:13 am
