Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to create a form where one field is expiry month & year (no date) and
set a data validation to ensure that this is current. I've learnt in other threads that you have to enter date, even if it's a hypothetical one, and have it not displayed. This'll work if I'm doing the data entry but it'll have to be made for the use of other people as well so I'd rather make it simple. How can I have four digits entered (without "/" or hyphen) to be recognised as mm/yy, displayed as "mm/yy" (or "mm-yy") and have the record validated to ensure that it is future month/year? -- Maki @ Canberra.AU |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Expiry Date calculation | Excel Discussion (Misc queries) | |||
VBA For Expiry date | Excel Discussion (Misc queries) | |||
Expiry date | Excel Worksheet Functions | |||
Date of expiry - warning? | Excel Worksheet Functions | |||
formulation of an expiry summary | New Users to Excel |