Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
Customized Date Format | Excel Worksheet Functions | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) |