Strip time off of Dates

roomale

New Member
Joined
Dec 4, 2003
Messages
48
From a monthly extract I have a series of dates that include the time in their entry e.g. 23/09/2006 09:01

Is there a simple way that I can strip the time element off of these dates and use just the date element of the cell. MAsking the date to dd/mm/yyy does not do as I requires as the time is still considered when I analyse dates in a pivot table.

Thanks
Andy
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Stormseed

Banned
Joined
Sep 18, 2006
Messages
3,274
From a monthly extract I have a series of dates that include the time in their entry e.g. 23/09/2006 09:01

Is there a simple way that I can strip the time element off of these dates and use just the date element of the cell. MAsking the date to dd/mm/yyy does not do as I requires as the time is still considered when I analyse dates in a pivot table.

Thanks
Andy

In excel....Do a text to columns and delimit by space...!
 

Watch MrExcel Video

Forum statistics

Threads
1,114,675
Messages
5,549,363
Members
410,911
Latest member
AniEx
Top