Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y

I have a list with a field that the date and the time is in the same cells
and is in the date and time format. (dd/mm/yyyy hh:mm). I need to be able to
use the date part of these cells on its own (dd/mm/yyyy) as a data date in a
seperate column for a pivot table. Can this be done from the new column using
a function/formula
--
nigeo
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,934
Default Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y

If A1 contains your date/time, then use this formula...

=INT(A1)

and format the cell as a Date.

--
Rick (MVP - Excel)


"nigeo" wrote in message
...
I have a list with a field that the date and the time is in the same cells
and is in the date and time format. (dd/mm/yyyy hh:mm). I need to be able
to
use the date part of these cells on its own (dd/mm/yyyy) as a data date in
a
seperate column for a pivot table. Can this be done from the new column
using
a function/formula
--
nigeo


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,651
Default Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y

On Wed, 1 Apr 2009 13:21:01 -0700, nigeo
wrote:

I have a list with a field that the date and the time is in the same cells
and is in the date and time format. (dd/mm/yyyy hh:mm). I need to be able to
use the date part of these cells on its own (dd/mm/yyyy) as a data date in a
seperate column for a pivot table. Can this be done from the new column using
a function/formula


I wonder if it is really necessary to split the two for the pivot table use.
However, with date/time in A1:

=INT(A1)

will return only the date. (Format as desired).
--ron
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y

=INT(A2)
--
David Biddulph

nigeo wrote:
I have a list with a field that the date and the time is in the same
cells and is in the date and time format. (dd/mm/yyyy hh:mm). I need
to be able to use the date part of these cells on its own
(dd/mm/yyyy) as a data date in a seperate column for a pivot table.
Can this be done from the new column using a function/formula



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Split DATE cell into three new cells? Xx Licher xX Excel Worksheet Functions 2 December 14th 07 11:16 PM
Split Date and Time Cell Beamers Excel Discussion (Misc queries) 2 May 19th 06 08:25 PM
Split the date & time in one cell to be 2 colums. Aom Excel Worksheet Functions 3 April 11th 06 03:27 PM
How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only? Wesley Accellent Excel Worksheet Functions 6 December 1st 05 08:03 PM
split combined Time Date cells Mark Ada Excel Discussion (Misc queries) 2 December 1st 04 04:06 AM


All times are GMT +1. The time now is 04:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"