Format Date
=DATE(YEAR(A1),1,1)
David Biddulph
"RandyG" wrote in message
oups.com...
what about a full column of different dates i want to change to
1/1/YYYY?
On Oct 18, 4:32 pm, Gary''s Student
wrote:
Very easy. If A1 contains 3/4/2006 then the formula:
=A1-62 will return:
1/1/2006
" wrote:
anyone aware on a formula that will change a date column ie: 3/4/2006
to 1/1/2006, I have a pivot table that only recognizes that format.-
Hide quoted text -- Show quoted text -
|