@BonnieB214 When you enter a 'year number' like 2023 and than format it as a date, Excel will turn it into the 2023rd day counting from January 1, 1900, which happens to be the 15th of July, 1905. That's where the 1905 comes from. In fact all 'year numbers' from 1828 to 2192 will turn into 1905.
If you want to use Excels time intelligence you need to enter dates properly. So, if your coin is from 2023, enter 1/1/2023 (or whatever format your local settings require) and then format it as a date with YYYY to show 2023.