Forum Discussion
Solved
need to get date gap
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.
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 Replies
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.
- this is really useful
thank you very muchRavindu94 You're welcome!
