nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Aging calculation

elfunambolo

Hello, I want to calculate aging in days as difference between a manual date inserted by me and dates coming from excel file attached.

The logic of date retrieved by excel is the following: for each row I need to consider starting from column BO (ACTION TYPE [PERFORMED BY]) the first field with Submitted word inside it (for example if BO is empty I need to go to BM, if BM is empty I need to go to BK etc..) until the first column ACTION TYPE [PERFORMED BY] filled with Submitted word and the that the date in the left column ACTION DATE.

So AGING = CUSTOM DATE - ACTION DATE

Thanks for support

Giovanni

Aging calculation.xlsx

Accepted answers

All comments

philipmannering

Hi @elfunambolo

See if the following helps...

Solution Attached.

Thanks,

Philip

Add Aging in Days.yxmd

elfunambolo

Thanks for help. I integrated your blocks inside my flow but AGING field at the end are empty.

Can you support me?

Thanks

Giovanni

WF billing FSE report.yxmd

elfunambolo

Is missing this part:

"The logic of date retrieved by excel is the following: for each row I need to consider starting from column BO (ACTION TYPE [PERFORMED BY]) the first field with Submitted word inside it (for example if BO is empty I need to go to BM, if BM is empty I need to go to BK etc..) until the first column ACTION TYPE [PERFORMED BY] filled with Submitted word and the that the date in the left column ACTION DATE."

OliverW

Hi @elfunambolo ,

feel free to check this one, I think this should do, what you are interested in, let me knof if this works.

I could not really make out what your "Custom Date" would be, so I just put at the end for the calculation the 1st of January 2020, but I am pretty sure you understand the concept in general.

If this works, please feel free to mark it as a solution as well as give a like.

Let me know in case you need any explanation in the workflow or if everything is understandable.

Best wishes

Olli

Aging Days Calculation_Oliver.yxmd

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703