I need to check if a cell contains a date value of particular format
(dd/mm/yyyy). It looks like isDate checks only for a date value and not the
format of the date. Is there any other function that i can use to do this.
thanks.
I need to check if a cell contains a date value of particular format
(dd/mm/yyyy). It looks like isDate checks only for a date value and not the
format of the date. Is there any other function that i can use to do this.
thanks.
MsgBox ActiveCell.NumberFormat = "dd/mm/yyyy"
"phil" wrote:
> I need to check if a cell contains a date value of particular format
> (dd/mm/yyyy). It looks like isDate checks only for a date value and not the
> format of the date. Is there any other function that i can use to do this.
>
> thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks