View Full Version : Help need for extracting the Date field
2011-08-16, 01:55 AM
I have a column that contains the following values....in Character format...
6/6/2011 8:00:00 AM
I want a extract the date portion from this field and place it in a separate field with Date Format so that I can group the data by Month.
2011-08-16, 02:17 AM
This should do the trick.
2011-08-16, 02:23 AM
Need generic formula for that Input format...I do not want to input the date value into this formula....
attached a sample file
2011-08-16, 02:25 AM
DATEVALUE is a function, converts text based dates to Excel dates.
2011-08-16, 02:27 AM
I understand Jesse..Please find the sample file attached.
2011-08-16, 03:04 AM
What is it that you want the data to look like for output, just the month number or name?
2011-08-16, 03:23 AM
I just want the date value to be extracted .....No timestamp.
If the input field is, 6/6/2011 8:00:00 AM
the output should be 6/6/2011
2011-08-16, 03:32 AM
What I gave outputs just the date but will be formatted based on whatever the cells are formatted as. If you wish to format it in the formula you could use:
To have it automatically format the date. If the cells are formatted to show time and date then Excel shows whole days with a time of 12:00:00AM.
2011-08-16, 03:39 AM
Tried it...Not working for me...
S NoSchedule StartOutput Value108/15/2011#VALUE!209/06/2011#VALUE!309/12/2011#VALUE!409/15/2011#VALUE!508/16/2011#VALUE!
Can you use the Excel file that I gave for testing this formula?
Thanks for your time and help.
2011-08-16, 03:53 AM
Try this. Your sheet doesn't have the the date stored as text, it has it stored as a date. To strip the time portion off all you need to do is drop the decimals.
2011-08-16, 03:56 AM
Thanks for the tip and formula.
Appreciate your time today in helping this one out.....
Powered by vBulletin® Version 4.2.0 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.