Multi Field Formula to Count Days between Dates Across Multiple Columns

A through E is what I currently have. I am trying to calculate the number of days between each one of the columns and get the output that is in columns E through J. So for column D2 the calculation to get I2 is the difference between the date and today's date. To get F5 it would be the difference between A5 and E5. Since there are two dates in that row it would be the difference between those two dates.

Basically I am looking to calculate the number of days between each stage but since some stages don't have dates I'm having trouble figuring out what the formula would be to calculate it.

Appreciate any help!!

Developer

Date Time

Expression

Accepted answers

atcodedog05

Hi @ColinMarc

Here is a updated workflow for the task. It should as per your requirement.

Check with your new data.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

stage_2.yxmd

All comments

atcodedog05

Hi @ColinMarc

You can try something like below.

DateTimeDiff(DateTimeToday(),DateTimeParse([Stage 1],"%m/%d/%Y"),"days")

Output:

Workflow:

Similarly for other days

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

stage.yxmd

ColinMarc

This is very close to what I am looking for but for the one in Stage 1 (Row 5) with the date 10/7/2020 I want the # of days to be the # of days between stage 1 and stage 5. So instead of the difference between the present day and date in Stage 1 it would be the # of days between stage 5 and stage 1.

Hopefully this makes sense thank you!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703