datevalue

[RUanExcelnut]

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.

[Ron Rosenfeld]

On Wed, 12 Jan 2005 12:07:04 -0800, RUanExcelnut
<[email protected]> 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

[Dave R.]

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" <[email protected]> wrote in message
news:[email protected]...
> 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.