|
|
#1
01-06-2020, 11:41 AM
|
|||
|
|||
Quarterly reoccurring training tracker
I have a requirement to track a persons 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.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Resource rejecting ALL occasions for reoccurring meeting | Youppie | Outlook | 0 | 08-26-2019 12:10 AM |
 Calculating Quarterly Dates by Months not Days
|
Artboy34 | Excel | 3 | 01-28-2016 09:47 AM |
|
reoccurring appointment that skips weekends
|
dovaka | Outlook | 1 | 04-10-2015 01:58 AM |
| Outlook 2003 - How to schedule Reoccurring Emails | techexpressinc | Outlook | 0 | 02-04-2011 02:51 PM |
|
Needs option to delete foward only when deleting reoccurring
|
Peter Grono | Outlook | 1 | 02-19-2006 04:22 PM |
Windows 10 
Office 2016
Linear Mode
