View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Beginning of Year

Put this in G5:

=DATE(YEAR(H4),1,1)

Format the cell as you wish to see it.

Hope this helps.

Pete

On Aug 26, 11:16*pm, Lucy wrote:
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?- Hide quoted text -


- Show quoted text -