TimRegan wrote:
Hi All,
. . .PS Bonus kudos if you can also tell me why MONTH returns 1 if passed
an empty cell as an argument?

If the empty cell is Cell A3, then you can see that =A3 returns 0, and 0
is the date serial number for January 1, 1900, or January 2, 1904,
depending on what date system you are using.

Alan Beban