Get rightmost non-date or text value in a row

Thanks for your feedback.

Please considder adding reputation to any helpers you think they deserve.
In that case please click * Add Reputationleft below their answers.