Analyse the TREND for only until a few days ago?

When the trend for last week only is to be concerned or just a specified period.
Something like - combining REF function and TREND ?