On Dec 27, 12:29*pm, atpgroups wrote:
On 27 Dec, 17:03, John Pierce wrote:

The following UDF works perfectly - except for the first line, i.e.
when CheckDate is a Sunday or Holiday. The result is #VALUE! but I
want just a blank or empty cell. How can I suppress or fix this?

The problem is that you have defined the function to return a Date,
and "" isn't a valid date. (The date datatype is a specialised numeric
type)
If you change the "...) *As Date" to "...) As Variant" it should
work.

Also note that an "If" doesn't need an "Else", and your "Else"s seem
to do nothing.

Thanks, changing 'as Date' to 'as Variant' in both places fixed it.