Thread: Quick and dirty function to test for MM/DD/YYYY value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Quick and dirty function to test for MM/DD/YYYY value
Hi Matthew,

Am Fri, 3 Jul 2015 06:21:10 -0700 (PDT) schrieb Matthew Dyer:

Looking for a simple function to accept variable COdate and just test to see if it is in MM/DD/YYYY format, give true if it is or false if it is not. Thanks!

test your CELL function.
In system with german language I can use:
=CELL("format",A1)="D4"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote