Take a look at Data Validation and see if that gets you what you want.

HTH,
Barb Reinhardt

"Dev" wrote:

Hi there,

Can we define a date format in a cell to restrict only dates with certain
formats can be entered.

Thanks for your help in advance.

Dev