View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Beginning of Year

What do you mean by calendar year? If you have a date in A1 and you want the
first date of the same year you can use

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

format as date


--


Regards,


Peo Sjoblom

"Lucy" wrote in message
...
I'm nowhere near the technical level as most of you on this site, so I'm
hoping you can help me out.

Isn't there a formula you can enter in Excel that will return the first
calendar year of a year?