Number Days Between two dates on columns

Fescobar

Hello Community,

I am looking to get and place the number of days on specific columns.

$ 13 WE 03/28/20

$ 13 WE 06/27/20

$ 13 WE 09/26/20

$ 13 WE 12/26/20

$ 4 w/e 01/25/20

For example on the second column I'd like to have the number of days between date on the first column. On the the third column the number of days between the date on the second column...so on and so forth.

This is the formula I have added...I was pretty certain that it wasn't going to work as expected.

Any help on this will be AWESOMELY appreciated.

Days Between.yxmd

Days Between Values in Columns.xlsx

Date Time

Accepted answers

AngelosPachis

Hi @Fescobar ,

Yes, a couple tweaks needed indeed to make this workflow work. Essentially the extra step was to add a record ID and the filter to split your data in to two streams, the one containing the column headers (which you have to edit) and the other the actual data.

At the end of the column header processing, you bring the stream back together with a union tool and then use a dynamic rename tool to make the first row of data the column headers.

Hope that makes sense, please reach out if you have any questions on the workflow.

Regards,

Angelos

Days Between_v3.yxmd

All comments

Emil_Kos

Hi @Fescobar,

I am not sure how to use your output but most basic way to calculate difference between two days would be using this formula:

DateTimeDiff([column1],[column2],'day')

AngelosPachis

Hi @Fescobar ,

Not sure when you want to put that date difference in that field, but I have placed that date difference at the end of each field.

So F1 has no date difference because it's the first one in that category of dates, but the F2 field comes 91 days later. The same goed for fields F3 and F4.

For F5, whatever comes at the front changes, so this is considered as a separate group, so nothing comes at the end, but F6 comes 28 days after F5 and so on.

Hope that makes sense, let me know if you have any questions on the workflow.

Cheers,

Angelos

Days Between_v2.yxmd

Fescobar

.@angelospachis

This is pretty awesome and from your explanation, it looks like a winner. I have additional columns on my spreadsheet that I didn't think were relevant; however, when I attach it and run the formula...they obviously are and I was totally wrong.

The dates are the only ones I need to count the day in between.

I am attaching a sample of the entire dataset that I am working with.

Thank you once again for lending a hand on this effort.

Days Between Values in Columns.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703