Here's the formula I came up with, which should be done in a Formula-Date field:
If(Month([Last Inspection Date]) = 3 or Month([Last Inspection Date]) = 4, AdjustMonth([Last Inspection Date], 5),
Month([Last Inspection Date]) = 8 or Month([Last Inspection Date]) = 9, AdjustMonth([Last Inspection Date], 7))
The Month([Last Inspection Date]) function retrieves the month number, so if the last inspection date is March, it will output 3, etc.
If the month of the last inspection date is March or April (3 or 4),
AdjustMonth([Last Inspection Date], 5) adds 5 months to the date. So if the last inspection date is March 1, 2022, the formula will result in August 1, 2022.
If the month of the last inspection date is August or September (8 or 9),
AdjustMonth([Last Inspection Date], 7) adds 7 months to the date. So if the last inspection date is September 30, 2022, the formula will result in April 30, 2023.
Does that make sense?
------------------------------
Ahuva Brown
------------------------------