Calculating Aging (only business days)

Question

Good Day Everyone !!

I have a field called Ageing. It is calculated as Current Date - Rec Date.

So if my Rec date is = 2023-04-15 and Current Date = 2023-04-25 then the Ageing = 10 days.

How do i calculate Ageing (Business days) - Which is ageing minus the weekends.

In the above example ageing business = 7 days.

Thanks for suggestions

philipmannering · Accepted Answer

Not very efficient, but you could generate dates between start and end and filter out those where the day is a Saturday or Sunday. See example attached,

ArnaldoSandoval · Accepted Answer

Hi @AbhijeetChib

The number of Business Days between two days, ignoring holidays is calculated by the formula below:

5 * [ Full Weeks ]  + 5 ( [Last Week Fraction] - [ Full Weeks ] )

Where:

Full Weeks = Floor( [ Days between dates ] / 7 )

Last Week Fraction = [ Days between dates ] / 7

Notes:

* Last Week Fraction is a floating number.
* We multiply by 5 because for Business Days, the week is 5 days.

This article explains the maths How many weeks between two dates

hth

Arnaldo