View Single Post
 
Old 01-06-2020, 11:41 AM
Paslay Paslay is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2020
Posts: 2
Paslay is on a distinguished road
Default 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.






Reply With Quote