Hello.
I have a range where several users should add dates when projects are supposed to be finished.
Unfortunately they tend to use different date formats.
I would like to force them to use YYYY-MM-DD format.
Is that possible?
I guess it is validation but I don't know how.
/Anders
With Data Validation you can force to enter a valid date between two dates.
Next is to format the cell to a Date you like e.g. dd/mm/yyyy
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Thanks.
Thought this could be easy to implement.
/Anders
... but it is very easy. See attachement. Try dates outside 2009
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks