Excel Formula turned into VBA

[rasinc]

I'd like to turn this formula

=  "pour " & TEXT(StartDate1, "MMM d, yyyy") & " à " & TEXT(EndDate1,"MMM d, yyyy")

into VBA code.

However, the code is part of a loop and each date increments. I was using dtStartDate as the variable for each start date that was reset at the beginning of each loop. dtEndDate is the end date.

I've tried various versions of

Range("A2") = "= & """"pour"""" & Text(" & dtStartDate & ", """"MMM d, yyyy"""") & """" à """" & Text(" & dtEndDate & ", """"MMM d, yyyy"""") & """""

but I am still having problems. Can anyone give me a hand, I'm hitting a roadblock tonight? TIA rasinc.

 

[Peter_SSs]

Try

Range("A2").Value = "pour " & Format(dtStartDate, "mmmm d, yyyy") & " à " & Format(dtEndDate, "mmmm d, yyyy")

 

[rasinc]

Thank you for the quick response Peter. It works great.

 

[Peter_SSs]

Thank you for the quick response Peter. It works great.

No problem - glad to help.