Forum Discussion

Syed Magdoom's avatar
Syed Magdoom
Copper Contributor
Oct 08, 2018
Solved

Days counting

Hello Community,   I have downloaded a report in csv file from our company service software. I have saved the file in "xlsx" format. I am trying to count days between the two dates but the results ...
Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Oct 08, 2018

    Hi Syed,

     

    This is because that's dates are formatted as texts not as numeric dates!

    To get the numeric value of each date, you have to use the DATEVALUE function along with the REPLACE function to remove days string DDD because it will handicap the DATEVALUE function!

     

    This is what you need:

    =DAYS(DATEVALUE(REPLACE(B2,1,3,"")),DATEVALUE(REPLACE(A2,1,3,"")))

    Please copy it into cell C2 and drag it down.

     

    Hope that helps

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Oct 08, 2018

Hi Syed,

 

This is because that's dates are formatted as texts not as numeric dates!

To get the numeric value of each date, you have to use the DATEVALUE function along with the REPLACE function to remove days string DDD because it will handicap the DATEVALUE function!

 

This is what you need:

=DAYS(DATEVALUE(REPLACE(B2,1,3,"")),DATEVALUE(REPLACE(A2,1,3,"")))

Please copy it into cell C2 and drag it down.

 

Hope that helps

  • Syed Magdoom's avatar
    Syed Magdoom
    Copper Contributor
    Oct 08, 2018

    Hello Haytham,

     

    Excellent! That worked. 

     

    Thank you so much for your timely help.

Resources