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
  • Chapter 9 of my free book on QP formulas, functions, and macros deals with conversions between text and numbers, including an article on @DATEVALUE. It contains an article with a number of sample formulas entitled "How to convert text dates/times into numeric dates/times."  Several of the samples are close to your example.

    It would be great if Corel would expand the formats that @DATEVALUE can use. That would make this common task simpler.

    Construct a working function in a cell to the right of the first cell in your range of cells.  Then copy that function down (usually) in parallel to the entire range of date-text cells.

    The book is here: http://corklaw.com/Tech/QP/QP_FormulasFunctionsMacros.pdf

    Charlie

Children
No Data