Forum Discussion
Dropdown list for Week of
Hello everyone, I am needing help with 2 things. 1. I am wanting to create a dropdown list that will have each Monday in 2021 listed but that Monday represents that entire week (Monday - Sund...
As per ISO 8601 the first week of 2021 started on 04th Jan 2021.
You must consider =WEEKNUM(A8,21) to retrieve the real week number.
If you want a list of all 2021 Mondays you can simply by array formula
=DATE(YEAR(FirstDate),1,-2)-WEEKDAY(DATE(YEAR(FirstDate),1,3))+(ROW(1:52))*7
Or based on first date you just add 7 days
Good to know Thank you for the info, bookmarked your response for future reference.
Anytime my friend.
Actually Microsoft has solved this "issue" creating for the new excel versions the formula
=ISOWEEKNUM(Date).
As I use to provide a more "democratic" solution that can be applied for many excel versions, I forgot to mention the new formula.- Good to know thank you