December 19, 200223 yr If Month Ref is janvier and Year Ref is 2002 then it should return de janvier de l'ann
December 20, 200223 yr Isn't it simpler to just do this: "de " & Month Ref & " de l'annee "& Year Ref or if the Month Ref may be empty: Case(IsEmpty(Month Ref),"N/A","de " & Month Ref & " de l'annee "& Year Ref)
Create an account or sign in to comment