fredthedog
New Member
- Joined
- Oct 12, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- MacOS
Hi I could really do with someones help.
Cells
A1 - this cell has a countdown to a certain date (63 weeks until tax is due) and will change every week automatically.
A2 - data input cell
A3 - I would like this cell to =IF(A2="","",A1) however I don't want it to change weekly like A1 does, so I want it to look at A1 and copy 63 weeks and next week when A1 changes to 62 weeks I want a3 to still say 63 weeks.
Is this possible?
Cells
A1 - this cell has a countdown to a certain date (63 weeks until tax is due) and will change every week automatically.
A2 - data input cell
A3 - I would like this cell to =IF(A2="","",A1) however I don't want it to change weekly like A1 does, so I want it to look at A1 and copy 63 weeks and next week when A1 changes to 62 weeks I want a3 to still say 63 weeks.
Is this possible?