Multi-Row Formulas and Generate Rows - Help with date Gaps in days

Question

Hi Everyone,

I am building a workflow where I needing the date difference in days creating a new column "difference"

Say example, 03/27/2019 and 01/20/2019 and the difference will be = 66 days

This need to be done in multirow formula.

Kindly help!

Sample Cases Data.xlsx

Mina2021 · Answer

Qiu,

I have done that part. I am building a different workflow and objective is to build the flow below format and I got stuck.

kindly help!

I am attaching the workflow.

Test_33.yxzp

Qiu · Answer

@Mina2021

Not considered meaning set to 0?

Mina2021 · Answer

Hi,

If the minus values are not considered then?