Does anyone have a formula for Excel that will make the cells read "this week" if the dates are from this week (today's date), and "last week" if the dates are from the previous week?
Ps: If the date range is neither this week nor last week, the formula should also read "old."
The dates in Column A, for instance, are as follows. Column B should indicate if the date falls within this week or the last week of the current date.
Column A |
Column B |
01/11/2013 |
Old |
02/11/2013 |
Old |
03/11/2013 |
Old |
04/11/2013 |
Old |
05/11/2013 |
Old |
06/11/2013 |
Old |
07/11/2013 |
Old |
08/11/2013 |
Old |
09/11/2013 |
Old |
10/11/2013 |
Old |
11/11/2013 |
Old |
12/11/2013 |
Old |
13/11/2013 |
Old |
14/11/2013 |
Last week |
15/11/2013 |
Last week |
16/11/2013 |
Last week |
17/11/2013 |
Last week |
18/11/2013 |
Last week |
19/11/2013 |
Last week |
20/11/2013 |
Last week |
21/11/2013 |
This Week |
22/11/2013 |
This Week |
23/11/2013 |
This Week |
24/11/2013 |
This Week |
25/11/2013 |
This Week |
26/11/2013 |
This Week |
27/11/2013 |
This Week |
28/11/2013 |
This Week |