Calculate the days

[Ronal_bal]

Hi Team,

I'm trying to calculate the no. of. Days from the current date to date marked in yellow where there is an output for Field E

Output= Current date - [date in field[A] until marked in yellow] +0.66

Need to sum until the data before yellow.

Example below:

2022-01-19 to 2022-02-16 is 29 days

= 29+0.66 = 29.66 days

[Luke_C]

Hi @Ronal_bal 

Can you attach the data? This can be done with multirow formula tools. 

[Ronal_bal]

Attached the example data.

[BS_THE_ANALYST]

I think I may have got what you needed?

[BS_THE_ANALYST]

I think this is another solution without the multi-row formula!

[Ronal_bal]

The solution only works one part i have dates for one value. I need for different parts performing the same for each part. Attached the file with different parts. Can you please provide a way

[Ronal_bal]

@BS_THE_ANALYST 

[ShankerV]

Hi @Ronal_bal 

Can you help me with the logic how it needs to be pop-ed up.

As I see the data's in random, could you please explain in detail.

So can help to fix your issue.

Many thanks

Shanker V

[BS_THE_ANALYST]

@Ronal_bal I think I've sorted it to what you want. Please confirm! :-)

[Christina_H]

Your dates are duplicated for Type 3, is that an error?  If so, here's a simplified version that works by counting the rows until there's a value in E then adding that value.