Update - Leave application. Issue: Forms dont allow leave application more than 2days

I have a leave application form that I have used for our company's leaves application online. When we apply for leave, we will receive an email notification of said leave being applied and an email notification to the approver.

The problem: When we apply a leave more than 1 day i.e. 2days, the form does not register the application nor it will send an email notification of said leave to us, and to the approver.

What we tried:
1. The system has worked for a long time, and the last application with success of more than 2 days is back in December. There wasn't any issue till January.
2. We have tried with different browser, different PC, different email and caches, and anything more than 1day, the problem arises.
3. Anything like 1 day or less, there is no issue. A notification will be sent to the applicant and the approver where the leave can be approved.
4. We have not modified or changed anything with the leave application form between the time period.

This is the form in question:
docs.google.com/forms/d/1LxRE29RkXOlOvoaQwghs4uqIDqkxVWO21aJQs_s8zCw/edit

This is the sheet in question:
docs.google.com/spreadsheets/d/1EkZHmxZZQvLEyr5gXhKWDonfPlDLAPLngSEadYg47x4/edit#gid=299715453

I believe that the problem maybe stemming from how the data is transferred from the forms to the sheets. However, date wise it looks like everything is in order, so I couldn't figure out what is triggering the #value! problem.
In the sheets, the green arrow is referring to those leaves that are more than 2days and wasn't able to show proper value (#value!)

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/for-other...han-2days.html