How to change dates into strings (skip weekoffs)

[Anjankumar2021]

Hi All,

could someone help me on the below issue. i want to change specific column date to String like T0,T1,T2 .

by skipping weekend day (Saturday and Sunday)

Input
30/06/2023	03/07/2023	04/07/2023	05/07/2023	06/07/2023	07/07/2023	10/07/2023	11/07/2023
Output
T0	T1	T2	05/07/2023	06/07/2023	07/07/2023	10/07/2023	11/07/2023

[Qiu]

@Anjankumar2021 
What is the logic for conversion date to Tx?

[Anjankumar2021]

day wise sales volume. those dates are column names, after conversation will apply filter

[Anjankumar2021]

day wise sales volume. those dates are column names, after conversation will apply filter

[Nezrin]

Create a field with sequence(1,2,3) and append with T.

Then use the formula tool to (i) convert to DateTimeFormat (ii) get the day of week using below

DateTimeFormat([DateField],"%A")

(ii) use if statement to skip weekends and replace

[Anjankumar2021]

weekoffs dates ( 01/07/2023 and 02/07/2023) already skipped or not in input data but want to convert next date to working date 03/07/2023 to T1 and 04/07/2023 to T2. pls help advise on T1 and T2

if we use if condition with

"IF Contains([_CurrentField_],DateTimeToday())
THEN "T0"
ELSE [_CurrentField_]
ENDIF"

i can easily convert todays date 30/06/2023 to T0 ( no issue with this)

[Anjankumar2021]

i mean next working days dates : 03/07/2023 and 04/07/2023 - want to convert in to T1 and T2