« Basic Functions : CELL | Main | Filling a Cell Range with a Series »
February 22, 2005
Converting text to dates
You have lots of dates to enter in your spreadsheet. This can be tedious when you have to format it correctly. Here is a formula that allows to to quickly enter dates as text.In the example below, we enter text in column B and convert to dates in column C. The conversion formula for C3 is
=DATEVALUE(LEFT(B3;2)&"/"&MID(B3;3;2)&"/"&RIGHT(B3;2))
Tomorrow, we will look at how to do this in a macro.
Posted by Dave at February 22, 2005 04:41 AM
Comments
See also
http://www.rondebruin.nl/qde.htm
for fast date entry
Posted by: Ron de Bruin at March 22, 2005 08:09 PM