Hi There,

I am sorry if i am repeating another post but i could not see one.
I have two date issues in a word VBA userform project.

I am using calendar control 12.0 and it retuns a date in form 9/2/13 i need it to be Sunday 9th Febuary 2013 please help.

secondly i have a textbox that populates info from a spreadsheet that works well the another text box that calcultes with the ADDDate function to add one year for example Texbox 1 = 30/6/2013 - textbox 2 = 30/06/2014 but the textbox2 return in a us date eg. 06/30/2014 i need it to be 30/06/2014 but the format i am using example below retrns a very strange date which is 11/02/13 this is the format code
Private Sub nfyee_Change()
Me.nfyee.Value = Format(Date, "dd/mm/yyyy")
End Sub

Thanks heaps.
Gordon