Formatting a date field

[Bob Matthews]

Is it possible to format a date field in excel such that :-
1) it accepts day, month, year or month, year or just year or blank and
2) you are able to sort properly on the field

Bob M

 

[JE McGimpsey]

Formatting has no effect on XL's input parser.


You may find you can work with this:

http://cpearson.com/excel/DateTimeEntry.htm