View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Franz Verga
 
Posts: n/a
Default Date and Text in one formula

Nel post
*Franz Verga* ha scritto:

[cut

="Nav at "&TEXT(DATE(YEAR(D3),MONTH(D3),0),"gg mmmm aaaa")


should be intende as:

="Nav at "&TEXT(DATE(YEAR(D3),MONTH(D3),0),"dd mmmm yyyy")

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy