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

Anjankumar2021

Hi Team /

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

Workflow

Accepted answers

binu_acs

@Anjankumar2021 updated the logic , try now

Date_25032025.yxmd

All comments

binu_acs

@Anjankumar2021 Can you try the attached workflow

Date_25032025.yxmd

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

workflow.yxmd

Anjankumar2021

@binu_acs

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

binu_acs

@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

Date_25032025.yxmd

Anjankumar2021

@binu_acs

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

binu_acs

@Anjankumar2021 updated the logic , try now

Date_25032025.yxmd

Anjankumar2021

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703