I want to calculate the time gap between the dates by Name.
for * marked cell, fill the cell with the number value(number of days difference between 04/12/2013 and 03/05/2013).
for Name B, there is just one date value, so just leave it Time Gap cell as '-'
Could anybody help me??
How about using this in the script?
If(Name=peek(Name),Date-peek(Date),'') as [Time Gap]
View solution in original post
What will be the difference between third A and 2nd A???
if(Peek(Name)=Name,(Date)-Peek(Date),'-') as Gap
(html, codepage is 1252, embedded labels, table is @1);
they are the same, 1st,2nd and 3rd A.