Filter out Date upcoming next 3 days including Today(need to exclude weekends - sat ,Sun

[Anjankumar2021]

Hi  Team /

@binuacs 

could someone assist on the below.

Need to filter out next 3 business days including Today. (if my current day is 28/03/2025 then it need to exclude Saturday 29/03/2025 and Sunday 30/03/2025)

Input
Date
2025-06-23
2025-06-16
9999-12-31
2025-04-03
2025-04-01
2025-04-02

Output

Date

2025-04-01

2025-04-02

2025-04-03

[binuacs]

@Anjankumar2021 Can you try the attached workflow

[Yoshiro_Fujimori]

@Anjankumar2021 ,

You may create the list of dates of "next 3 days" and then filter your data with Join tool.

Workflow

Formula

[Date] = DateTimeAdd(DateTimeToday(),[RowCount],"day")

[DayOfWeek] = DateTimeFormat([Date],"%a")

Filter

[DayOfWeek] NOT IN ("Sat", "Sun")

Output

Date

2025-04-01

2025-04-02

2025-04-03

[Anjankumar2021]

@binuacs 

not able to get output with your logic. could you please check and advise.

need to filter date with current day +2 days(need to exclude weekends both sat and sun).

that means output as  01/04/2025, 02/04/2025 and 03/04/2025

[binuacs]

@Anjankumar2021 The logic is looking for dates which are current day + 2, ie you should see only 4/1/2025 in the output, i updated the formula to consider only the date part 

[Anjankumar2021]

@binuacs 

what i needed is , i want to filter out upcoming next three days only (includes current day + tomorrow +day after tomorrow). if these 3 days falls in weekend , need to skip.

i got the accurate output with basic filter tool. but my doubt is filter tool can skip weekends?

Output:

01/04/2025

02/04/2025

03/04/2025

[binuacs · Accepted solution]

@Anjankumar2021 updated the logic , try now

[Anjankumar2021]

got the accurate output. thank you so much for your help......