Home |
Search |
Today's Posts |
#1
|
|||
|
|||
DATEIF Name error
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 |
#2
|
|||
|
|||
try datedif rather than dateif
"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 |
#3
|
|||
|
|||
On Mon, 12 Sep 2005 07:59:10 -0700, 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 The correct name of the worksheet function is DATEDIF. ^ (You left out the second "D"). But for days between dates, simpler might be =H2-C2 and format as General or Number. --ron |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
ERROR | Excel Discussion (Misc queries) |