#1
|
|||
|
|||
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.
|
#2
|
||||
|
||||
Try:
=DATE(YEAR(A1),CEILING(MONTH(A1),3)+1,1) where A1 contains traning date... copy across to get next quarter, etc... |
#3
|
|||
|
|||
I believe it works!!!! thanks...
|
Thread Tools | |
Display Modes | |
|
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 |