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.

Those look like the same format to me.

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

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.

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

On Oct 18, 4:31 pm, JLGWhiz wrote:
Those look like the same format to me.



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

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 -

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