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!