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?
|