formula problem

  • Thread starter Thread starter dab
  • Start date Start date
D

dab

hi
the below formula seems to work fine in excel 2002 but not in 2000.

=+IF(I2="0000-00-00";"";IF(I2="";"";IF(I2>NOW()-7;"W";IF(I2>NOW()-14;"W-1";IF(I2>NOW()-21;"W-2";IF(I2>NOW()-28;"W-3";"W-4"))))))

date format in column I:
14/06/2004

any ideas
 
try changing the semicolons to commas, it worked on 2000 for me afte
making the change.

hth

Mik
 
Just a point: the semicolons are used, in some countries, rather than the
English comma.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
dab > said:
the below formula seems to work fine in excel 2002 but not in 2000.

=+IF(I2="0000-00-00";"";IF(I2="";"";IF(I2>NOW()-7;"W";
IF(I2>NOW()-14;"W-1";IF(I2>NOW()-21;"W-2";IF(I2>NOW()-28;"W-3";"W-4"))))))
Click to expand...
....

Precisely how does this formula not work in XL2K?
 
Sorry, but once I'd changed the ";" to "," I didn't find it a problem. Other
than the semicolons it was properly constructed for an "English speaking"
machine :-(

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
Back
Top