SCOOBYDOO Wrote:
Hi, I have to find the difference between two dates, the first (and
earlier
date) is in column C, cells C2 - C5910 and the second is in column H,
same
row references. The dates are in a dd/mm/yyyy format. I have input
the
following in column I - =DATEIF(c2,h2,"d") which I expected to return
the
number of days between the two dates, however, I am getting a "#NAME?"
error.
Can anyone help please?

Thanks

Hi Scoobydoo

Try DATEDIF


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=466812