View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Franz Verga
 
Posts: n/a
Default Converting Day Numbers to Dates...

Nel post
*Don Guillett* ha scritto:

shorter than my offering but it also works without the value, even if
text =DATE(YEAR(TODAY()),1,A1)

Yes, I didn't think that also the DATE function makes the conversion from
text to value..

--
Ciao

Franz Verga from Italy