HI All I have a task to get the start date and end date of the week with the given week number Startdate will be monday end date will be sunday For example Week number is 42 means i need dates like Start date - 10-10-2022 End Date - 16-10-2022 @Yoichi @Rahul_Unnikrishnan @ppr Regards Clint…

Hi, How about the following? targetYear = 2022 weekNumber = 42 dateJan1 = New dateTime(targetYear,1,1) Then dateJan1.AddDays(7*(weekNumber-1)-CInt(dateJan1.DayOfWeek)+1) dateJan1.AddDays(7*(weekNumber-1)+7-CInt(dateJan1.DayOfWeek)) Sequence.xaml (6.5 KB) Regards,

Get the start date and end date based on week number

Learning Hub Academic Alliance

Clinton_Das (Clinton_Das) October 14, 2022, 9:22am 4

Thank You @Yoichi for the input ,learned something new !

Regards
Clinton

1 Like

Topic		Replies	Views
How to get week from specified date range Studio excel , uiautomation , activities , studio , week-1 , week-2 , week-3 , week-4 , date , datetime , month	5	24	February 5, 2025
How to get the start date and end date of the week in the month Help	1	2969	October 10, 2019
Get Monday date for specific week number Activities excel	4	1155	July 9, 2022
Get monday date from specific week number Activities activities , question , system	10	2361	July 9, 2022
How to get start and end date of every current week Studio studio , question , tools	2	1227	January 30, 2023

Get the start date and end date based on week number

Related topics