converting text dates to formula

Hi all.
I would like to convert a range of text dates in the format:  <Dec 10, 2018 > to the standard QPW formula date, which unformatted would be <43444>. Now, I could figure out how to write an equation using text parsing (I think), but is there some easy, automated way of making this conversion over a rather long range of cells?
Thanks.
Steve Berer

Parents
No Data
Reply
  • Look at the @DateValue function.   See the formats accepted in help.  Use text parsing to get your date into this format.   It looks like either 10-Dec-2018 or 10-Dec-18 will work for your example.

    Or post your query over at WPUniverse.com where you are likely to get a more timely response and better advice than I can give.

Children
No Data