Date value won't work in formulas.
 

I have a spreadsheet in which several columns are dates. However, I cannot
get Excel to use the values from those columns for computation.

The column's first cell value is shown as 6/1/2006. THe cell format is as
*3/14/2001. WHen I try to do any computations with it, including using
datevalue to try to convert it, I get a #VALUE! error message.

I tried to be sneaky and used a new column with formulas = K2+0 to try to
convert the cells. The new column computes the values fine but when will
also return #VALUE when I try to use them for computing.

Date value won't work in formulas.
 

=datevalue() is used to convert text strings to real dates.

It sounds like your values are already dates.

You should be able to use that value with no conversion.

Steven wrote:

I have a spreadsheet in which several columns are dates. However, I cannot
get Excel to use the values from those columns for computation.

The column's first cell value is shown as 6/1/2006. THe cell format is as
*3/14/2001. WHen I try to do any computations with it, including using
datevalue to try to convert it, I get a #VALUE! error message.

I tried to be sneaky and used a new column with formulas = K2+0 to try to
convert the cells. The new column computes the values fine but when will
also return #VALUE when I try to use them for computing.

--

Dave Peterson