Datedif

[wymkyl]

I am having a problem makeing Datedif work in Excel 2007,somebody
mentioned that there is abug in Excel 2007 working with diffrent date
format and it gives a diffrent answer depending on the format. I am
having no luck to give any answer it always returnes #NAME# or
#VALUE#. anybody has an answer to this problem?

 

[David Biddulph]

You forgot to tell us what formula you are using, and what are the contents
of the cells that are being used by the formula.

 

[Ron Rosenfeld]

I am having a problem makeing Datedif work in Excel 2007,somebody
mentioned that there is abug in Excel 2007 working with diffrent date
format and it gives a diffrent answer depending on the format. I am
having no luck to give any answer it always returnes #NAME# or
#VALUE#. anybody has an answer to this problem?

It works for me.

There maybe some problem with your data; or with the formula you are using; or
you have found something real. But with the limited amount of information
you've provided, I can't tell.
--ron

 

[John]

Hi
You can check this link for information on "Dateif" or show us your formula
http://www.cpearson.com/excel/datedif.aspx
HTH
John