Expiry Date validation

[derbys]

Hey folks,

Im drawing an absolute blank when its comming to validating a cell that is to hold an expiry date and am after a little help/hints. Basically what i want to happen is that the cell (H25) should hold the form mm/yy much like a credit card. Also im wanting to make sure that say if the month is out of date then a message will appear saying so, same as if a year is out of date.

Also i dont want it to accept anything other then digits, which is proving difficult for me especially as i want to us a / in the input cell.

any help would be appreciated, im spectacularly stuck atm.

[royUK]

You should be able to use Data Validation

[derbys]

I've tried doing it through the data validation button, but it doesn't work. and as far my (limited) excel knowledge tells me, you cant do that many complicated validations through the data validation button.

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

How do you know that the date has expired?

Format the cell as mm/yy & restrict entry to dates