How to convert this number 18174 to June 23, 2018 in Excel?

[minhhieule89]

I just received a report in which has this number 18174, I know for sure it equals to June 23, 2018 but Excel date value is 43274

is there a way to convert that 18174 to the right date format in Excel?

 

[minhhieule89]

Not unless all your dates are in 2018.

great, thank you again