PDA

View Full Version : Simple way to know Control Panel status



jack nt
09-04-2011, 01:16 AM
There is a very simple way to know when ask Day("1/2/2003") = ?
If Day("1/2/2003") = 1 then Control Panel is of "d/m/y"
ElseIf Day("1/2/2003") = 2 then Control Panel is of "m/d/y"

Jack NT

Bob Phillips
09-04-2011, 03:52 AM
Try

=IF(DAY(A2)=1,TEXT(A2,"d/m/y"),TEXT(A2,"m/d/y"))

jack nt
09-04-2011, 06:41 AM
Try

=IF(DAY(A2)=1,TEXT(A2,"d/m/y"),TEXT(A2,"m/d/y"))

Thank xld very much.