View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lucy Lucy is offline
external usenet poster
 
Posts: 37
Default Beginning of Year

Sorry, clarification: I have a date in the format (mm/dd/yyyy), say in cell
H4. I wish to enter a formula, say in cell G5, that would return 01/01/yyyy
of the year in cell H4. Is there such a formula?

"Gary''s Student" wrote:

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?