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