First Day of the Year

[Andrew Mackenzie]

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

 

[Peo Sjoblom]

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

where A1 holds 26/03/08

--


Regards,


Peo Sjoblom

 

[Andrew Mackenzie]

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]

Also note that EOMONTH is an ATP function and many businesses
do not have it installed (it needs to be installed in versions before 2007)
meaning that if somehow your spreadsheet ends up on a machine where it is
not installed
it will return a name error

--


Regards,


Peo Sjoblom