On Fri, 6 Jan 2006 14:26:39 +0100, "Ron Dean" wrote:

Point taken, I am now using YEAR and it works fine.
However if you go to HELP in Excel VBA there is a description of DatePart
Function. This is what I based my formula on.

DatePart is a valid **VBA** function. It is NOT an Excel *Worksheet* function.

I'm glad you've got it working.


--ron