excel 2007 datedif function question (1 Viewer)

[martinr]

i have a problem with the datedif function in Excel 2007, (it displays
#NUM! when i try to use it).

I know this isn't an Excel forum - can someone recommend one?
Thanks.

 

[Galaxiom]

It will be an invalid paramater passed to one of the arguments. Eg Empty cell.

Note that the arguments are in a different order and use different period string from DateDiff() in Access.

http://www.techonthenet.com/excel/formulas/datedif.php

There is an Excel section at this forum.
http://www.access-programmers.co.uk/forums/forumdisplay.php?f=55

 

[Brianwarnock]

The link says that it is for Excel 2000 and 2003 , but it also works in 2013.

I posted the original Datedif help in this thread

http://www.access-programmers.co.uk/forums/showthread.php?p=1242773&highlight=datedif#post1242773

Brian