Mixed Date Separator Parsing Fails

[ibrahim-sadiqi]

Description

The parser fails to handle date inputs that use mixed separators, while Excel correctly interprets them as valid dates.

Example

• Input: "2021/1-10"

Expected Behavior (Excel)

• Parsed as a valid date
• Format interpreted as m/d/yyyy (locale-dependent)

Actual Behavior (Library)

• Returns null

Notes

• Excel supports flexible date parsing even when separators are mixed (e.g., / and -)
• The parser should normalize or handle mixed separators before attempting date parsing