Announcements
Hi all you experts
I have a text label with a Week Number and I need to get the corresponding Month Name in another text label, is that possible?
The text label is just a text label with a number between 1 and 52.
Thanks.
Is Week 1 the first 7 days of the year, Week 2 the second 7 days, etc.? You'll going to need a 53 because 7x52=364 which means there are 1-2 days in Week 53 of any given year. Is this always going to be for the current year, or is the year user-selected?
Yes week 1 is always the first week of the year. It will always be for the current year.
If TextInput1 contains the number of the week then this will give the name of the month containing the first day of that week:
Text(Date(Year(Today()),1,Value(TextInput1.Text)*7-6),"mmmm")
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 383 Super User 2026 Season 2
Mohsin Ali 356
WarrenBelz 232 Most Valuable Professional