Beginning of Year
Put a year in A1 and in A2, enter:
=DATE(A1,1,1) then format A2 as dddd to display:
Tuesday
--
Gary''s Student - gsnu200801
"Lucy" wrote:
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?
|