Date Format

C

Connie Martin

Two people using the same form with a =weekday formula in a cell. The date
must be a Wednesday. When one person types 12/21/05 it accepts that date and
puts it in. When another person types 12/21/05 it won't accept it and the
customized message pops up saying this isn't a Wednesday. So, the person
types 21/12/05 and it accepts it, putting it in as 12/21/05. What gives?
Connie
 
R

Ron Rosenfeld

Two people using the same form with a =weekday formula in a cell. The date
must be a Wednesday. When one person types 12/21/05 it accepts that date and
puts it in. When another person types 12/21/05 it won't accept it and the
customized message pops up saying this isn't a Wednesday. So, the person
types 21/12/05 and it accepts it, putting it in as 12/21/05. What gives?
Connie
Click to expand...

Excel's date parser is controlled by the Windows Regional Settings short date.
Your number 2 person has his set to a DMY variation.

Run/Control Panel/Regional & Language Settings


--ron
 
Top