View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Validating Dates

????

I get

?format([date(2005,13.5,34)], "mmm/dd/yyyy")
Feb/02/2002

or

?format([date(2005,13.5,34)], "mmm/dd/yyyy")
Feb/03/2006

depending on which Date system I'm using, but nothing like what you
got...


In article ,
"Norman Jones" wrote:

?format([date(2005,13.5,34)], "mmm/dd/yyyy")
Mar/06/2005