If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing cell contents so that Excel recognises it as a date
You can also wrap the cell references in the DATEVALUE function such as:
=DATEVALUE(B1)-DATEVALUE(A1) where B1 is the end date as text and A1 is the beginning date as text. Also if you have a whole column (say column A) of dates that you want to convert you can enter =DATEVALUE(A1) and so forth in another column to get dates (of course this column must be formatted as a date. "Dave Peterson" wrote: Changing the format the cell won't change the value of the cell. After you reformat the cell, try reentering the data. Depending on what you have in the cell, hitting F2, then enter may be enough. Mifty wrote: Hi there, Is there a simple way to convert data in to recognisable date format? What I want to do is calculate the difference between start and finish dates, but the data has already been entered and excel is not recoginsing it as a date even when it has been re-formatted as a date. I would be so grateful for any help! :-) -- Mifty -- Dave Peterson |
#2
|
|||
|
|||
Changing cell contents so that Excel recognises it as a date
Erin,
Thanks for the reply. Will try this on Monday at work and will let you know how it goes. Cheers -- Mifty "Erin Searfoss" wrote: You can also wrap the cell references in the DATEVALUE function such as: =DATEVALUE(B1)-DATEVALUE(A1) where B1 is the end date as text and A1 is the beginning date as text. Also if you have a whole column (say column A) of dates that you want to convert you can enter =DATEVALUE(A1) and so forth in another column to get dates (of course this column must be formatted as a date. "Dave Peterson" wrote: Changing the format the cell won't change the value of the cell. After you reformat the cell, try reentering the data. Depending on what you have in the cell, hitting F2, then enter may be enough. Mifty wrote: Hi there, Is there a simple way to convert data in to recognisable date format? What I want to do is calculate the difference between start and finish dates, but the data has already been entered and excel is not recoginsing it as a date even when it has been re-formatted as a date. I would be so grateful for any help! :-) -- Mifty -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
In Excel, Get todays date in a cell | tbw | General Discussion | 2 | October 6th, 2005 12:08 AM |
have a calendar pop up in a cell to pick & insert a date in excel | helevansen | Worksheet Functions | 3 | September 29th, 2005 09:37 PM |
Copy cell format to cell on another worksht and update automatical | kevinm | Worksheet Functions | 21 | May 19th, 2005 11:07 AM |
QDE (Quick Date Entry) | Norman Harker | Worksheet Functions | 37 | September 5th, 2004 01:24 AM |
QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |