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?

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.
--
David Biddulph

wrote in message
...
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?

On Mon, 22 Dec 2008 01:00:23 -0800 (PST), wrote:

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

Hi
You can check this link for information on "Dateif" or show us your formula
http://www.cpearson.com/excel/datedif.aspx
HTH
John
wrote in message
...
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?