Hi All,
Please could you help - I have got myself in a muddle with my IF statements.
In cell A1 I have an end date. If the date in A1 is more than 21 days ago from today then I was B1 to return "Archive". If A1 is blank I want it to leave cell B1 blank.
Eg: A1 17/11/2017 B1 "blank"
A2 04/08/2017 B1 Archive
Thank you![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Please could you help - I have got myself in a muddle with my IF statements.
In cell A1 I have an end date. If the date in A1 is more than 21 days ago from today then I was B1 to return "Archive". If A1 is blank I want it to leave cell B1 blank.
Eg: A1 17/11/2017 B1 "blank"
A2 04/08/2017 B1 Archive
Thank you
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)