Excel 2010 and DateDiff Missing

[jimmyjazz16]

--- Problem 2 - Mr Excel Forum


Change this formulae needed so it works in Excel 2010 version who have no datediff formula available ? Getting hundreds of client sites to upgrade in 24 hrs not possible.


=IF(ISBLANK(U15), "", DATEDIF(U15,$V$3,"y") & " y, " & DATEDIF(U15,$V$3,"ym") & " m ")


in V is the 02/04/2017.




Output Expected is 35 y, 4 m

 

[RoryA]

Welcome to the forum.

DATEDIF is available in Excel 2010. What makes you think it isn't? If it's just the fact it doesn't appear in the formula dropdown, don't worry about that - it will still work.

 

[jimmyjazz16]

This is an excel spreadsheet with this formulae in 2 columns that is sent out to hundreds of sites. When it comes back completed, the Datediff in the formulae is disapeared in both columns, and replaced with #Name! . Reading online apparently there is versions of Excel 2010 that do not have datediff function as standard, and if the file is open and saved in this version this is what happens.

http://www.excelforum.com/showthread.php?t=799862

 

[RoryA]

If you read that thread, the issue is not with DATEDIF not being available, it's with it being used incorrectly.

 

[jimmyjazz16]

You are right . Reading that article again. The suggestion was that the formula in one form worked on one computer and not another. But I have the quotes in my formula I sent out, so that is not the issue. Thats why I was thinking of a different formula without datediff.