I would like to auto populate 6 columns based on dates entered in adjacent cell.

Once a date in entered, 6 columns will prefill with 90, 60, 30 days out and 90, 60, and 30 days in the past.