Calculating number of days between dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two very long lists of dates. I need to calculate the difference in the number of days between the series of dates. I know it is possible to use "" and include the date to calculate individual examples - but I need a formula to calculate the entire series
Do I need to format the data before attempting to calculate from it
What is the formula I need
At present the dates are listed as dd/mm/yyyy

Thank

CJ
 
Hi Sov!

It is very rare for posts not to appear. Just be patient.

Answer below to your post was:

It looks like your dates are not dates but are text.

Check using =ISTEXT(A1)

If this returns TRUE, then you have text.

Convert to numbers by
Select a blank cell
Copy
Select the "dates"
Edit > Paste special > Add
OK

Now you should see the date serial number
Format as dd/mm/yyyy

Use B1-A1 to calculate the days difference.

#VALUE! is the error message that indicates the wrong type of argument
or operand is used and in this case it's because you are trying to use
maths on text.

To get faster response to message postings connect through
msnews.microsoft.com

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Sov said:
I have two very long lists of dates. I need to calculate the
Click to expand...
difference in the number of days between the series of dates. I know
it is possible to use "" and include the date to calculate individual
examples - but I need a formula to calculate the entire series.
 
Back
Top