hello, i have start date and end date mentioned in excel i need to get week for that same week. cehck below ss [image] here output is - week 5 so i need week number for above dates how can i get that? help m eon same

@Mathkar_kunal , Check this one weekNumber = DatePart(DateInterval.WeekOfYear, DateTime.ParseExact("2025-01-26", "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture), FirstDayOfWeek.Sunday, FirstWeekOfYear.System)

How to get week from specified date range

Help Studio

Mathkar_kunal (Mathkar, kunal) February 5, 2025, 4:19pm 3

it is week 5

but showung in outpt as 4

why?

Topic		Replies	Views
Date Automation Activities excel , activities , question	4	618	October 17, 2022
Split a Month into Weeks with respect to Work Days Studio datatable , studio , datetime	1	959	February 14, 2023
Get Month from Week number Studio	5	1439	August 8, 2020
Find dates when week and year given StudioX excel , studiox , question	6	1046	April 2, 2022
Convert Week & Weekday to Date Help studio	7	3403	September 23, 2019

How to get week from specified date range

Related topics