Thread: First Day of the Year
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew Mackenzie Andrew Mackenzie is offline
external usenet poster
  
Posts: 50
Default First Day of the Year
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


Reply With QuoteReply With Quote