Expiry mm/yy and validation

M

Maki

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?
 
B

Bob Phillips

It's easy enough but a bit more background will help.

When you say a for, do you mean a userform, or a pseudo-form within a
worksheet? If the former, is the date to be entered by the user in a
textbox?
 
M

Maki

Thank you, Bob,

It's really the latter, just a spreadsheet and no macro or VBA scripting
involved.

Would it be more complicated or less?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change DD/MM/YY to MM/DD/YY 6
Change from mm/dd/yy to yy/mm> 3
date 2
MM/YY Formatting date Entry AND Display 2
Entering dates into cells as mm/yy or yy 4
Entering date as MM/DD/YY no longer works, why? 1
Convert date to text without changing format dd/mm/yy 3
visual basic user form date format dd/mm/yy not mm/dd/yy 1

Top