Converting relative readable dates (like "1 week ago") back to date stamps (like dd/mm/yyyy)

Hey, I'm trying to reverse engineer dates from free text fields from a file extract.

For example, using the value of "1 week ago", I'd like to subtract that from todays date and turn it into "28/01/2025". The date format isn't too crucial, just so long as it's considered a date value that can be manipulated into pie charts later.

Other example values include "3 years ago", "Last month", "20 minutes ago".

Basics trying to reverse engineer what DATEDIF outputs when using k as the unit.

Is this possible? Thanks in advance!