Forum Discussion

Ravindu94's avatar
Ravindu94
Brass Contributor
May 27, 2020
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.
admin
developer
excel
Excel for web
Macros and VBA
office 365
training
User Adoption
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 28, 2020

    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.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 28, 2020

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.

  • Ravindu94's avatar
    Ravindu94
    Brass Contributor
    May 28, 2020
    this is really useful
    thank you very much