Date Format in table

Rahulwork

Board Regular
Joined
Jun 9, 2013
Messages
244
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

Well-known Member
Joined
Dec 30, 2008
Messages
7,467
Office Version
2019
Platform
Windows
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
 

Forum statistics

Threads
1,086,207
Messages
5,388,438
Members
402,118
Latest member
Scott Hughson

Some videos you may like

This Week's Hot Topics

Top