The random dates are in the range AV2:IV10 and not AV2:BB10

"mac_see" wrote:

I have nothing in range AS2:AS10
I have some random dates in range AV2:BB:10

What I want to do is, check the difference between the two dates AW2-AV2 and
keep it in memory, then check difference of AX2-AW2, keep it in memory... do
this till BB2-BA2 and whichever number is highest in the memory, put in it
cell AS2. Continue the same thing till row 10.

Also whatever is the difference of the last dates (BB2-BA1), put it in cell
AT2..... do this till row 10.

Maxi