Find dates when week and year given

Hi everyone,

For below example, week 12 and year 2022 was given.

Is there any way to do this? Can excel formula do this? Thanks!

@Low_Hua_Kuan Can you please elaborate this?


I am so sorry as I think it is more relatable to Excel problem instead of StudioX but I really need someone to help me…

User can input particular week and year, and the table will show up the dates in that week and year (7 days).


Result come out:

I would want to know what formula can I use to obtain those dates, eg. 19/March, 20/March…Thanks!!


Check this workbook
Dates.xlsx (9.7 KB)

1 Like

Hi @Low_Hua_Kuan ,

Could you give this a try?

Enumerable.Range(0,7).Select(Function(s) System.Globalization.CultureInfo.InvariantCulture.Calendar.AddWeeks(New DateTime(int_year,01,01),int_weekdau).AddDays(s-7).ToString("dd/MMMM")).ToList()

Kind Regards,
Ashwin A.K

1 Like

Thank you everyone!!! :grin:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.