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