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
--
Gary's Student



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