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 ...

Dates.xlsx70 KB

Formulas and Functions

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

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

Copper Contributor

Oct 08, 2018

Hello Haytham,

Excellent! That worked.

Thank you so much for your timely help.

Forum Discussion

Days counting

Resources