Validation

[Panchi]

How can I limit input of A1 to a specific date format i.e. dd.mm.yy

From cell A1, I would like to extract the month and display as mmm in cell A2

Thanks

 

[Dave Peterson]

You could format the cell the way you want and use data|validation (in xl2003
menus) to restrict the entry to a date.

Then in B1, you could use a formula:
=if(a1="","",text(a1,"mmm"))

Be aware that data|validation is easily broken (copy|paste will crush it). But
it should work if the user is typing something.

ps. The user will be able to type the date the way they like and the formatting
will show it to you as you like.

Personally, I'd use an unambiguous format like: dd-mmm-yyyy

 

[Panchi]

Hi Dave,

I have used the formula as you have advised but the cell shows the whole
date as in A1 and not the month itself.

Panchi

 

[Panchi]

Its OK Dave... its work perfect........ I had a validation set on the cell
but when i removed it, your formula worked perfect. Thanks