Thanks Peo,

Before I saw your reply i got to =EOMONTH(A1,-(MONTH(A1)))+1

But yours is clearly a much more elegant answer.

Cheers,

Andrew


"Peo Sjoblom" wrote in message
...
=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