May 27 2020 11:47 PM
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.
May 28 2020 12:16 AM - edited May 28 2020 12:27 AM
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.
May 28 2020 12:16 AM - edited May 28 2020 12:27 AM
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.