How would you convert February 23, 2016 to a date value without using the DATEVALUE function? I get the #Error result from my formula if I use the function.

1 Answer 1


The DATEVALUE function is used to convert Date/Time values into just a Date value. If you want to convert a Text value into a Date value, try using DATE(text). See Using Date and Date/Time Values in Formulas for more help with Date and Date/Time formulas.

  • Touched up your formatting a bit. Hope you don't mind. Welcome to SFSE!
    – Adrian Larson
    Jul 19, 2016 at 18:36
  • Haha no Adrian that is totally fine. Looks better now lol.
    – cmmoutes13
    Jul 19, 2016 at 18:37
  • @loggedinuser please mark this as the best answer if it resolved your issue. If it did not then please let us know what is still not working.
    – cmmoutes13
    Jul 19, 2016 at 20:32

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .