Date Format

[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

[Ron Rosenfeld]

On Tue, 10 Jan 2006 09:02:08 -0800, "Connie Martin"
<ConnieMartin@discussions.microsoft.com> 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

[Connie Martin]

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"
> <ConnieMartin@discussions.microsoft.com> 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
>