I need some formula to work out whether a data is this week or last week
So if date Serial is within last 7 days "this week"
if date serial is between 7-14 days old, last week
Maybe theres a smarter way?
Basically i have a string of dates and im trying to work out whether its this week or last week