#NUM! Error when date is derived from reference

Hello.

I am working with relatively simple formulas to determine holidays based on the year.

When I type the year into the cell, the formula works fine, but, when I enter a reference into the cell to derive the year, the formula results with a #NUM! error.

EXAMPLE-1: When I type the year (e.g. 2019) into $Y$3, the formula '=DATE(Y3,1,1)' in $Z$3 returns 'January 1, 2019'. Works fine.

EXAMPLE-2: '=MONDAY!$H$1' in $Y$3 returns the year based on the date in the referenced cell. However, now '=DATE(Y3,1,1)' in $Z$3 results with a #NUM! error.

I'm stumped and any help would be greatly appreciated.

Thanks!

The value in MONDAY!$H$1 is a date e.g. '04-01-2019'

That's it! Thank you 6StringJazzer! (great handle btw)

Glad to help, and thanks for the rep!

I am a jazz guitarist who masquerades as an IT manager so I can pay the bills.