Date Format
 

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

Date Format
 

On Tue, 10 Jan 2006 09:02:08 -0800, "Connie Martin"
wrote:

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

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

Date Format
 

Duh! I should've known that! Having one of those days! Thank you.

"Ron Rosenfeld" wrote:

On Tue, 10 Jan 2006 09:02:08 -0800, "Connie Martin"
wrote:

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

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