How to enter array constants correctly

Hi all, pls see the attached example.

Why does e.g. the workday function allow dates to be array-entered like this {"1/1/2000"} while XNPV does not but does only accept the serial number equivalent of that date?

Thanks