need to get date gap

[Ravindu94]

Hi,

here with my excel. i need to get date gap for highlighted column. formula only working with 1st cell others shows wrong value, can anyone look in to my excel and help me soon.

[#2 · Accepted solution]

@Ravindu94 First of all you need to change G1 in the formula that calculated the "date gap" to $G$1 and most "dates" in column C are not real dates. Deducting a text from the date in G1 returns an error.

Used Text-to-columns to make real dates. See attached.

[#3]

this is really useful
thank you very much

[#4]

@Ravindu94 You're welcome!