Calculate aging from received date till yesterday without weekend.

Hey @ArijitRoy,

Heres on way of doing this:

Any questions or issues please ask
HTH!
Ira

Hey @ArijitRoy,

Pretty similar problem:

Hey @ArijitRoy,

I've changed the workflow:

It now always includes the start date even if its on a Saturday.

Any questions or issues please ask
HTH!
Ira

All comments

Hey @ArijitRoy,

Heres on way of doing this:

Any questions or issues please ask
HTH!
Ira

Thanks @IraWatt,

It is working perfectly. Thank you very much for your support. 😁

No worries @ArijitRoy ! Glad it worked for you 😄

Hi @IraWatt,

Need your help on the same issue. The file I have shared there are 3 columns. Kindly delete the last column and help me with the solution. Query is the same. I have attached a new file.

Book1.xlsx

Hey @ArijitRoy,

Pretty similar problem:

Hi @IraWatt,

On the excel there are 339 records and output is showing 338.

Sorry good spot @ArijitRoy,

The issue was that zero days have passed for record 1:

I've updated the workflow to fix that.

Hi @IraWatt,

Thanks for your help but found another problem. If you check in the input file for the date 4th June,22 (06/04/22), it is the received date but 4th is Saturday hence in the output you will not find the date.

Hey @ArijitRoy,

I've changed the workflow:

It now always includes the start date even if its on a Saturday.

Any questions or issues please ask
HTH!
Ira

There is something wrong with the days count.

Count starts from the received date. First date will be counted as 0 then 1 and 2 and so on and till previous day of the current date. If the received date is Saturday then it should count the day from Monday. If 4th June 22 is Saturday then count should start from 6th of June 22. I am new and unable to apply the Excel's Networkdays formula into Alteryx.

rohitashsharma

Hi Arijit,

May be it can be calculated with the help of formula, would request you to try if it helps you

Steps-

1) After input use a formula tool and create a new column "Aging 2" and use formula "DateTimeDiff(DateTimeToday(),[Received_Date],"Days")" with "Fixed Decimal" data type without using decimal values

2) Add another column in the same formula tool " Weekends" and use expression "DateTimeDiff(DateTimeToday(),[Received_Date],"Days")*2/7" with "Fixed Decimal" data type without using decimal values

3) Add another final column "Actual Aging" and use formula "[Aging 2]-[Weekends]"

Hope it helps.

Thanks,

Rohitash