Format Date

[astroak]

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.

 

[JLGWhiz]

Those look like the same format to me.

 

[Gary''s Student]

Very easy. If A1 contains 3/4/2006 then the formula:
=A1-62 will return:
1/1/2006

 

[RandyG]

the month and date need to be changed to 1/1

Those look like the same format to me.

 

[RandyG]

what about a full column of different dates i want to change to
1/1/YYYY?

 

[David Biddulph]

=DATE(YEAR(A1),1,1)

David Biddulph

what about a full column of different dates i want to change to
1/1/YYYY?