datevalue
 

While using the DATEVALUE(date_text) formula, I am trying to use a cell
location (ie. c3) in the (date_text) field instead of text. Is this
possible? It is part of a formula to sum numbers between two dates and I am
trying to make it simple for others to use.

On Wed, 12 Jan 2005 12:07:04 -0800, RUanExcelnut
wrote:

While using the DATEVALUE(date_text) formula, I am trying to use a cell
location (ie. c3) in the (date_text) field instead of text. Is this
possible?

Yes.
--ron

As long as C3 contains a text date, it will work.

You can also use something like this which works on both text dates and
actual dates.

=DATEVALUE(TEXT(A1,"mm/dd/yyyy"))



"RUanExcelnut" wrote in message
...
While using the DATEVALUE(date_text) formula, I am trying to use a cell
location (ie. c3) in the (date_text) field instead of text. Is this
possible? It is part of a formula to sum numbers between two dates and I
am
trying to make it simple for others to use.