Getting a value for a single date from X days ago

My data has gaps in the date field (non-consecutive dates). I need a rate value for a single date from X days ago (30, 60 ...), and if the date X days ago has no value (that day is missing in the da...