formula problem

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
 
F

Freemini

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

hth

Mik
 
A

Andy Wiggins

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"
 
H

Harlan Grove

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?
 
A

Andy Wiggins

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"
 
Top