Automatic Spill

link - exceljet.net/articles/why-some-excel-functions-wont-spill 

Most of the functions can return multiple values and will automatically spill.
However there are some functions from Excel 2003 that will not spill automatically and will return #VALUE!
It is possible to get these functions to spill by just prefixing the cell range with a plus sign.

The following functions do not spill automatically
EDATE
EOMONTH
ISODD
ISEVEN
NETWORKDAYS
WEEKNUM
WORKDAY
YEARFRAC