Excluding weekoffs i need date

[lokesh_segu]

above excel snap is a dummy data. actually i need the date using get text activity. so as like excel i need to add +2 days for every date excluding weekoffs(satarday and sunday).

Thanks & Regards,
Lokesh.

[THIRU_NANI (NaNi)]

Hi! Welcome to community!

For calculating business days…

Calculate Business Days - RPA Component | UiPath Marketplace | Overview

For adding 2 days…

How to add 5 business days to the date

Hi, The best solution for this would be a especific workflow. In my case i build a “GetNextNWorkDay” build a workflow: 2 in atributtes: 1. DateOrigin 2. Number of days 1 out atribute: 1. DateOut Workflow should be like: dateOut=dateorigin for each Enumerable.Range(0,Math.Abs(Number of days)) do dateOut = dateOut.AddDays(NumberOfDays/Math.Abs(Number of days)) Note: this will work forwards and backwards if only want one direction just place +1 or -1. while ({DayOfWeek.Saturday,DayOfWeek.…

Regards,
NaNi

[Yoichi]

Hi,

Another solution:

Can you try the following expression?

dateTimeVar = DateTime.ParseExact(yourStringFromGetText,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture)

resultDateTime = dateTimeVar.AddDays(Enumerable.Range(1,2).Sum(Function(i) if({DayOfWeek.Saturday,DayOfWeek.Sunday}.Contains(dateTimeVar.AddDays(i).DayOfWeek),2,1)))

If you need string, use ToString like resultDateTime.ToString("dd/MM/yyyy")

Regards,

[lokesh_segu]

Thank You for the reply@yoichi. i am facing error . if possble can you please share me the xml.

[Yoichi]

Hi,

Hope the following helps you.

Sample20211231-1.zip (2.4 KB)

If there is possibility your string contains extra whitespace, please use Trim method as the following.

dateTimeVar = DateTime.ParseExact(yourStringFromGetText.Trim,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture)

Regards,

[postwick (Paul)]

Don’t use Get Text for Excel. Use Read Range to read the sheet into a datatable. Then manipulate the data in the datatable to what you want. Then Write Range back to the sheet.