EXCEL: Date Late Submission

[yakult014]

Hi, I want to show if textDate.value is equal or is not greater than 1 day textDateSubmission.value show "On Time".
Then if the textDate is greater than one day to textDateSubmission show (Days of late)" days late"

if TextBoxDate - TextBoxReceived > 1, TextBoxReceived - TextBoxDate "days late on time","On time"))

Is this possible?

 

[Yongle]

Convert the values in the 2 textboxes to valid dates and compare the converted values
One way if date entered as text in both textboxes ...

Private Sub TextBoxReceived_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    Dim recd As Date, due As Date, txt As String
    txt = "On Time"
    recd = CDate(TextBoxReceived.Text)
    due = CDate(TextBoxDate.Text)

    If recd > due Then txt = recd - due & " days late"
    textDateSubmission.Text = txt
End Sub

 

[yakult014]

Convert the values in the 2 textboxes to valid dates and compare the converted values
One way if date entered as text in both textboxes ...

Private Sub TextBoxReceived_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    Dim recd As Date, due As Date, txt As String
    txt = "On Time"
    recd = CDate(TextBoxReceived.Text)
    due = CDate(TextBoxDate.Text)

    If recd > due Then txt = recd - due & " days late"
    textDateSubmission.Text = txt
End Sub

View attachment 14184

Wow amazing sir. Is it possible sir to not use button. Can we use afterUpdate?

 

[Yongle]

Use whatever you prefer
I used textbox_EXIT

 

[yakult014]

Use whatever you prefer
I used textbox_EXIT

I'm done sir. Thank you so much for your help.