In a workbook I have a date in cell A1, In cell A2 there is a formula which shows either "pending" or "complete", what I need is for cell A3 to show the date when cell A2 changes to "complete". I then need cell A4 to show the difference in days between the date in A3 and a date in cell A1.
Does that make sense and is it possible?
Thanks.