datevalue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
Click to expand...

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