Woody19722
03-10-2017, 07:27 AM
I am trying to use the date value it was working but for some reason it is showing #Value now. When evaluating the formula it shows the correct answer until you complete the eval.
=datevalue(A2)
3/9/2017
#VALUE!
Thank you.
=datevalue(A2)
3/9/2017
#VALUE!
Thank you.