Forum Discussion
catherine9910
Sep 22, 2021Brass Contributor
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...
Juliano-Petrukio
Sep 23, 2021Bronze Contributor
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
Yea_So
Sep 23, 2021Bronze Contributor
Good to know Thank you for the info, bookmarked your response for future reference.
- Juliano-PetrukioSep 23, 2021Bronze Contributor
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.- Yea_SoSep 23, 2021Bronze ContributorGood to know thank you