3

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.

5

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.

| improve this answer | |
  • Touched up your formatting a bit. Hope you don't mind. Welcome to SFSE! – Adrian Larson Jul 19 '16 at 18:36
  • Haha no Adrian that is totally fine. Looks better now lol. – cmmoutes13 Jul 19 '16 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 '16 at 20:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.