Topper,

Okay here is the latest, when I opened both spreadsheets, that I'm working
with. The sheet where I am selecting my dates from, when I select a cell an
click on the arrow to show all the dates available to me, all I see is Excel
number format, but IF I click on one of those numbers, then and only then
what I click on changes into a date. Therefore I have to quess what number
corresponds to what date.

And I double checked and both sheets have the same date format.

Steve