Find dates when week and year given

[Low_Hua_Kuan]

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!

[ushu (Usha kiranmai)]

@Low_Hua_Kuan Can you please elaborate this?

[Low_Hua_Kuan]

Hi,

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!!

[sarathi125 (Parthasarathi)]

@Low_Hua_Kuan,

Check this workbook
Dates.xlsx (9.7 KB)

[ashwin.ashok ((TheCodingTheory))]

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

[Low_Hua_Kuan]

Thank you everyone!!!