Excel glitch? (Userform Textbox = Format, "Date")

Good day,
I just want to point out a small glitch or am I doing something wrong?
I have the following code that makes my Textbox3 from my Userform add the date format to “YYYY-MM-DD”

I came across yesterday a weird date glitch... When I selected 2013-11-12 it gave me 2013-12-11 but this means December 11, 2013 I want November 12, 2013. Today it works perfect and it writes down the code in accordance to the code, but still doesn’t take the November 12, 2013... Why?
Userform Code:

Private Sub TextBox3_Change()
TextBox3.Value = Format(TextBox3.Value, "YYYY/MM/DD")
End Sub

Private Sub TextBox3_Enter()
    frmne.TextBox3.Value = ""
    frmCalendar2.Show
End Sub

Note: Plus my Column is set to Custom "YYYY-MM-DD"

Because I have multiple date entries within the same userform, I have multiple calendars set up (total 3), the reason why 3, is that I am able to control multiple date entries to specific textbox without adding dates to multiple textbox... each textboxs is triggered by it's own calendar.

So for this textbox3 I have frmCalendar2.Show that pop-up and I can select my date from this calendar form and on selection it transfers the info to my textbox3.

For the calendar I had some trouble adding multiple entries to different textboxs. If I had for example Textbox3 and textbox4 with date entries... I would add the code:

Private Sub Calendar1_Click()
    frmne.TextBox3.Value = Calendar1.Value
    frmne.TextBox4.Value = Calendar1.Value
    Unload Me
End Sub

But it would add the date in both textbox, I know i'm missing something to use only one calendar but that would be another thread

_______________________

I have the following calendar2:

Private Sub Calendar1_Click()
    frmne.TextBox3.Value = Calendar1.Value
    frmamendment.TextBox4.Value = Calendar1.Value
    frmcontract.TextBox5.Value = Calendar1.Value
    frmtermination.TextBox6.Value = Calendar1.Value
    frmoptionyear.TextBox3.Value = Calendar1.Value
    Unload Me
End Sub

Private Sub Calendar1_DateClick(ByVal DateClicked As Date)
   On Error Resume Next
   Texbox.Value = DateClicked
   Unload Me
End Sub

Private Sub cmdClose_Click()
    Unload Me
End Sub

Then in my userform I have the following code (not all code but only for Textbox3)

Private Sub TextBox3_Change()
TextBox3.Value = Format(TextBox3.Value, "YYYY/MM/DD")
End Sub

and

Private Sub TextBox3_Enter()
    frmne.TextBox3.Value = ""
    frmCalendar2.Show
End Sub

Problem is that if November 12, 2013 is selected it shows as 2013-12-11 but the code sais that the format is YYYY-MM-DD... I need it to show as November 12, 2013 and not December 11, 2013...

But November 13, 2013 works perfect... I am so confused

Got it I have changed

frmne.TextBox3.Value = Calendar1.Value

to

frmne.TextBox3.Value = Format(Calendar1.Value, "yyyy-mm-dd")

this fixes it :D

Thank you Norie :D

Here Is a test you just have to select New Entry (Command Button).

Datetest.xlsm