This is what I needed. Thanks so much!

For those who are on Macs and reading this for further information:
On the Excel menu, click Preferences, and then click Calculation.
That's where you find the 1904 selection.

I don't really know how to make that the default setting, but that's how
it's fixed.
=)

"RagDyer" wrote:

XL has 2 date systems.
Since you're on a Mac, could very well be that the Mac default system is the
1904, while the data you're receiving is the standard 1900.

<Tools <Options <Calculation tab.
--
HTH,

RD