Changing cell contents so that Excel recognises it as a date

M

Mifty

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! :)
 
D

Dave Peterson

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.
 
E

Erin Searfoss

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.
 
M

Mifty

Thanks for the reply.

--
Mifty


Dave Peterson said:
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.
Click to expand...
 
M

Mifty

Erin,

Thanks for the reply. Will try this on Monday at work and will let you know
how it goes.

Cheers
--
Mifty


Erin Searfoss said:
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.
Click to expand...
 
Top