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]

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"))