Thread: 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
<RUanExcelnut@discussions.microsoft.com> 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" <RUanExcelnut@discussions.microsoft.com> wrote in message
news:B7067DA2-1263-4602-8AF8-B698EA12A809@microsoft.com...
> 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.