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
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
