Thread
:
Check how date is entered
View Single Post
#
2
Posted to microsoft.public.excel.programming
dpb
external usenet poster
Posts: 109
Check how date is entered
On 5/4/2018 2:31 AM,
wrote:
Is there anyway to check with VBA if a date is entered as DD-MM-YY or MM-DD-YY?
How can I tell using VBA if 4-5-18 is actually 4th of May of Fifth of April?
If that's all you have in isolation you can't...if there are a string of
dates such that can find a value 12 in the (presumed) month field then
you can make the presumption that's days and the other must be months
but without some additional hints or such a specific day that can be
recognized there's just insufficient data to be unequivocal.
--
Reply With Quote
dpb
View Public Profile
Find all posts by dpb