Mar 29 2021 03:17 PM
Mar 30 2021 01:07 AM
SolutionAutomatically having a date that you enter is not a good idea - it can easily lead to errors.
If you accidentally click in the formula bar and press Enter without changing anything, another 4 months would be added to the date, without a trace of what happened.
Instead, enter the achievement day in one cell, for example E1, and use a formula to calculate the expiration date in another cell, for example F1. This leaves you with a visible check that the dates are 4 months apart.
Mar 30 2021 01:07 AM
SolutionAutomatically having a date that you enter is not a good idea - it can easily lead to errors.
If you accidentally click in the formula bar and press Enter without changing anything, another 4 months would be added to the date, without a trace of what happened.
Instead, enter the achievement day in one cell, for example E1, and use a formula to calculate the expiration date in another cell, for example F1. This leaves you with a visible check that the dates are 4 months apart.