Dears good evening
I come to ask for help, for a formula that I need to elaborate.
Enclosed, ou will find an example of the datas that I have in my archive, where I need to calculate the quantity of days between two days.
Always consider the date in column D less the date in column E, but only if number is the same in column J.
Considering Number CRSU9217122
Row 1, because E is blank, nothing will appear, we will leave it blank.
Row 3, we need to consider D5 - E3 (because is the same number in column J)
Row 5, we need to consider D7 - E5
In this example we have only two different numbers in column J, but it can happen that I will have 3, 4 up to 10 different numbers.
In resume, what I need is to find a way to calculate the quantity of days between two dates, if number in column J is the same
Maybe I will need to use VBA, I am a bit confused.
Hope someone will be able to help me.
In case of any doubt, do not hesitate to leave a message.
In advance Thank you !