Forecast Quarterly Tasks

[snoman]

Hello All!

After countless hours of research, I have created an account so that I can have my question answered directly.

I have quarterly training that must be accomplished by the end of each quarter, but those dates are based on an "Initiation" date. Based on THAT date, I need to:

1) calculate the quarter the Initiation date falls into (not displayed)
2) display the final day of the quarter after that of the Initiation Date to reflect the "Due By" date for the next quarter's appointment
3) display last days of each subsequent quarter in their respective columns

(don't mind the colors at this point)

[TABLE="width: 248"]
<tbody>[TR]
[TD="width: 82, bgcolor: transparent"]Initiation
[/TD]
[TD="width: 82, bgcolor: transparent"]Supplem
[/TD]
[TD="width: 82, bgcolor: transparent"]Midway
[/TD]
[TD="width: 82, bgcolor: transparent"]Supplem
[/TD]
[/TR]
[TR]
[TD="width: 82, bgcolor: #00B050"]Mar-19

[/TD]
[TD="width: 82, bgcolor: #00B050"]Jun-19
[/TD]
[TD="bgcolor: #00B050"]Sep-19
[/TD]
[TD="bgcolor: #00B050"]Dec-19
[/TD]
[/TR]
[TR]
[TD="width: 82, bgcolor: #00B050"]Sep-19
[/TD]
[TD="width: 82, bgcolor: #00B050"]Dec-19
[/TD]
[TD="bgcolor: #00B050"]Mar-20
[/TD]
[TD="bgcolor: #00B050"]Jun-20
[/TD]
[/TR]
[TR]
[TD="bgcolor: #00B050"]Jul-19
[/TD]
[TD="bgcolor: red"]Dec-19
[/TD]
[TD="bgcolor: yellow"]Mar-20
[/TD]
[TD="width: 82, bgcolor: #00B050"]Jun-20
[/TD]
[/TR]
[TR]
[TD="width: 82, bgcolor: #00B050"]Feb-19
[/TD]
[TD="width: 82, bgcolor: #00B050"]Jun-19
[/TD]
[TD="bgcolor: #00B050"]Sep-19
[/TD]
[TD="bgcolor: red"]Dec-18
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Logit]

.

=IF(A2="","",DATE(YEAR(A2),((INT((MONTH(A2)-1)/3)+1)*3)+1,1)-1)

Other formulas included in workbook.

Download : https://www.amazon.com/clouddrive/share/QHm7mcWV1LKAqaf6oJjPcTDykX7ycBNpuku73bjKM70