m/d/Y date format parsed incorrectly

[parmonov98]

1️⃣ Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before? (Currently 3.1.x)
3.1
2️⃣ What version of the package, Laravel and PHP do you use? Please provide the FULL version number.
laravel 8.12, php 7.4,
3️⃣ Describe your issue. Please be short, but concise.
I don't understand how I 'm getting the marked value in dd output.

m/d/Y date format parsed incorrectly

4️⃣ How can the issue be reproduced? Please provide easy-to-reproduce steps (repository, simple code example, failing unit test).
create a cell with m/d/Y date format and impoirt it. it is converted automatically to some number.
5️⃣ What should be the expected behaviour?
3/31/2021 in my case

6️⃣ Have you filled in the entire issue template? If not, your issue will be closed. Thanks for using the package! 🙌
yes

[patrickbrouwers]

Please report to phpspreadsheet, we don't do any date handling.

[leyvicaz]

@parmonov98
see this comment #1832 (comment).

[miraclegly]

try it $tmp = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($date);