=DATE(YEAR(A1),1,1)

where A1 holds 26/03/08

--


Regards,


Peo Sjoblom

"Andrew Mackenzie" wrote in message
...
Hi,

Can anyone tyell me how to write a formula that will give me the first day
of the year for a given date. So 26/03/08 will return 01/01/08, 22/07/09
will give me 01/01/09 etc.

Many thanks in advance.

Cheers,

Andrew