Quarterly reoccurring training tracker
I have a requirement to track a person’s annual trainingdate and it the training expiration date which occurs after 12 month (at theend of the month). That part I have. I need help with a formula to track the quarterlyrefresher training that must occur based on the initial training date. The standard quarters are used, Jan-Mar,Apr-Jun, Jul-Sep, and Oct-Dec. I needhelp with a formula for each quarter. For example, if the initial training occurs any date in Jan, Feb or Mar,I need a formula in the next cell to show Apr 20 or Apr 2020 or 1 Apr 20(something to that effect). The nextcell would show Jul 20, and the last cell to show Oct 20.
|