Date Format in table

[Rahulwork]

Hello Everyone

I have a workbook contains multiple sheets having same coloum header

B D And G columns are for date ..

I want if any one put date under above mentioned columns, it should be in dd-mmm-yy else it should not accept or pop up an error that pls provide date in correct format.

I need this function on all sheets.

Pls help

 

[jasonb75]

provide date in correct format.

A date format is just that, a format!

To be valid, dates need to be entered in either a recognised format for your regional settings, or a valid international format. Anything other than that you simply do with cell formatting.
You could use data validation to check that the dates fall within a specified period if needed. https://www.contextures.com/exceldatavalidationdates.html