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