Is it possible to pre-populate a date in a column after date in adjacent column is entered?
Here is what I have been tasked with:
If date is on or before (<=) the 6th of the month (e.g. 01/01/2019) then the pre-populated date should be 21st of the following month (+1 month) (e.g. 21/02/2019)
If date is after (>) the 6th of the month (e.g. 07/01/2019) then the pre-populated date should be 21st +2 months (e.g. 21/03/2019)
The pre-populated will always be start with the 21st day of the month.
Any help with this is greatly appreciated