Date & Time, show only date

[shonaart]

Hi
Column A: has a date & time ( 23 Feb 2011 13:50 )

I want column B to look at column A: and only have the date, no time. ( 23 feb 2011 )When I link column A: to B: and format column B: to DD:MMM, it still has the time. ( can see the time in the top formula bar still )

The reason I need just the date is because when I create my pivot table , the pivot does not combine all the same dates, as the times are still there.

Pleas help , thanks

 

[Aladin Akyurek]

Hi
Column A: has a date & time ( 23 Feb 2011 13:50 )

I want column B to look at column A: and only have the date, no time. ( 23 feb 2011 )When I link column A: to B: and format column B: to DD:MMM, it still has the time. ( can see the time in the top formula bar still )

The reason I need just the date is because when I create my pivot table , the pivot does not combine all the same dates, as the times are still there.

Pleas help , thanks

Try...

B1, copy down:

=INT(A1)

Format the formula cell as date.

 

[shonaart]

Thank you so much for the help

 

[Aladin Akyurek]

Thank you so much for the help

You are welcome. Thanks for providing feedback.