I have installed an excel 2003 template on 5 different computers that are all
running excel 2003. I have now struck a computer that gives a ###value
error. The problem area on the template are two columns that run a formulas
as follows:
=IF(I2="",0,(DATEDIF(I2,TODAY(),"Y")=3)+0) in column B
=IF(I2="",0,(DATEDIF(I2,TODAY(),"Y")<=2)+0) in column C
Why would this formula suddenly come up with this error now? While I was
installing on the problem PC and I put my memory stick that I install from in
my laptop to check that there was nothing wrong with the template and the
template worked perfectly fine. There are no other formula's except in those
two columns. Paste links from columns B & C to columns D & E, some
conditional formating in column H, and thats it. Has worked and is still
working perfectly fine on all the other PC's.
Could someone please help with this. It is obviously to do with this
computer only but maybe someone has some answers.
Thanks
Sue

Hi Sue

Check the date for Today() on the 2 computers.
Or, is the value in I2 on those computers today() 10/Nov/2005.
That will give an error.

Regards

Roger Govier


Sue wrote:
I have installed an excel 2003 template on 5 different computers that are all
running excel 2003. I have now struck a computer that gives a ###value
error. The problem area on the template are two columns that run a formulas
as follows:
=IF(I2="",0,(DATEDIF(I2,TODAY(),"Y")=3)+0) in column B
=IF(I2="",0,(DATEDIF(I2,TODAY(),"Y")<=2)+0) in column C
Why would this formula suddenly come up with this error now? While I was
installing on the problem PC and I put my memory stick that I install from in
my laptop to check that there was nothing wrong with the template and the
template worked perfectly fine. There are no other formula's except in those
two columns. Paste links from columns B & C to columns D & E, some
conditional formating in column H, and thats it. Has worked and is still
working perfectly fine on all the other PC's.
Could someone please help with this. It is obviously to do with this
computer only but maybe someone has some answers.
Thanks
Sue

Hi Roger,
Cell I2 is formatted to 1/02/05 style and that is how it presents.
Not sure what you mean by "check the date for Today() on the computer".
Where do I go for that? Do you mean going to check if the computer is
showing the correct date in it's system?
If I've misunderstood your second suggestion of: today() 10/Nov/2005 please
let me know what you mean.
Just beginning this sort of stuff.
Thanks
Sue

"Roger Govier" wrote:

Hi Sue

Check the date for Today() on the 2 computers.
Or, is the value in I2 on those computers today() 10/Nov/2005.
That will give an error.

Regards

Roger Govier


Sue wrote:
I have installed an excel 2003 template on 5 different computers that are all
running excel 2003. I have now struck a computer that gives a ###value
error. The problem area on the template are two columns that run a formulas
as follows:
=IF(I2="",0,(DATEDIF(I2,TODAY(),"Y")=3)+0) in column B
=IF(I2="",0,(DATEDIF(I2,TODAY(),"Y")<=2)+0) in column C
Why would this formula suddenly come up with this error now? While I was
installing on the problem PC and I put my memory stick that I install from in
my laptop to check that there was nothing wrong with the template and the
template worked perfectly fine. There are no other formula's except in those
two columns. Paste links from columns B & C to columns D & E, some
conditional formating in column H, and thats it. Has worked and is still
working perfectly fine on all the other PC's.
Could someone please help with this. It is obviously to do with this
computer only but maybe someone has some answers.
Thanks
Sue

Hi Sue

Datedif expects the first date to be earlier than the second date, otherwise
it returns an error.
That is why I was asking whether I2 was greater than today's date which is
10th November, or, more likely as you have the problem on just 2 computers,
is their current date and time setting incorrect.

Type =Today() in a blank cell and see what it returns.

Regards

Roger Govier


Sue wrote:
Hi Roger,
Cell I2 is formatted to 1/02/05 style and that is how it presents.
Not sure what you mean by "check the date for Today() on the computer".
Where do I go for that? Do you mean going to check if the computer is
showing the correct date in it's system?
If I've misunderstood your second suggestion of: today() 10/Nov/2005 please
let me know what you mean.
Just beginning this sort of stuff.
Thanks
Sue

"Roger Govier" wrote:


Hi Sue

Check the date for Today() on the 2 computers.
Or, is the value in I2 on those computers today() 10/Nov/2005.
That will give an error.

Regards

Roger Govier


Sue wrote:

I have installed an excel 2003 template on 5 different computers that are all
running excel 2003. I have now struck a computer that gives a ###value
error. The problem area on the template are two columns that run a formulas
as follows:
=IF(I2="",0,(DATEDIF(I2,TODAY(),"Y")=3)+0) in column B
=IF(I2="",0,(DATEDIF(I2,TODAY(),"Y")<=2)+0) in column C
Why would this formula suddenly come up with this error now? While I was
installing on the problem PC and I put my memory stick that I install from in
my laptop to check that there was nothing wrong with the template and the
template worked perfectly fine. There are no other formula's except in those
two columns. Paste links from columns B & C to columns D & E, some
conditional formating in column H, and thats it. Has worked and is still
working perfectly fine on all the other PC's.
Could someone please help with this. It is obviously to do with this
computer only but maybe someone has some answers.
Thanks
Sue

Hi Roger,
The date in column I will always be less than today's date as they are dates
of birth.
As it is only the one computer it doesn't work on I will travel back out
there and check their computer's date. If there is anything else that you
can think of as a possible scenario I would really appreciate it as they are
not immediately local for location and it would save me another trip out
there.
Thanks
Sue

"Roger Govier" wrote:

Hi Sue

Datedif expects the first date to be earlier than the second date, otherwise
it returns an error.
That is why I was asking whether I2 was greater than today's date which is
10th November, or, more likely as you have the problem on just 2 computers,
is their current date and time setting incorrect.

Type =Today() in a blank cell and see what it returns.

Regards

Roger Govier


Sue wrote:
Hi Roger,
Cell I2 is formatted to 1/02/05 style and that is how it presents.
Not sure what you mean by "check the date for Today() on the computer".
Where do I go for that? Do you mean going to check if the computer is
showing the correct date in it's system?
If I've misunderstood your second suggestion of: today() 10/Nov/2005 please
let me know what you mean.
Just beginning this sort of stuff.
Thanks
Sue

"Roger Govier" wrote:


Hi Sue

Check the date for Today() on the 2 computers.
Or, is the value in I2 on those computers today() 10/Nov/2005.
That will give an error.

Regards

Roger Govier


Sue wrote:

I have installed an excel 2003 template on 5 different computers that are all
running excel 2003. I have now struck a computer that gives a ###value
error. The problem area on the template are two columns that run a formulas
as follows:
=IF(I2="",0,(DATEDIF(I2,TODAY(),"Y")=3)+0) in column B
=IF(I2="",0,(DATEDIF(I2,TODAY(),"Y")<=2)+0) in column C
Why would this formula suddenly come up with this error now? While I was
installing on the problem PC and I put my memory stick that I install from in
my laptop to check that there was nothing wrong with the template and the
template worked perfectly fine. There are no other formula's except in those
two columns. Paste links from columns B & C to columns D & E, some
conditional formating in column H, and thats it. Has worked and is still
working perfectly fine on all the other PC's.
Could someone please help with this. It is obviously to do with this
computer only but maybe someone has some answers.
Thanks
Sue