Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2020, 11:41 AM
Paslay Paslay is offline Quarterly reoccurring training tracker Windows 10 Quarterly reoccurring training tracker Office 2016
Novice
Quarterly reoccurring training tracker
 
Join Date: Jan 2020
Posts: 2
Paslay is on a distinguished road
Default 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.








Reply With Quote
  #2  
Old 01-06-2020, 01:05 PM
NBVC's Avatar
NBVC NBVC is offline Quarterly reoccurring training tracker Windows 10 Quarterly reoccurring training tracker Office 2016
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Try:


=DATE(YEAR(A1),CEILING(MONTH(A1),3)+1,1)


where A1 contains traning date... copy across to get next quarter, etc...
Reply With Quote
  #3  
Old 01-06-2020, 01:50 PM
Paslay Paslay is offline Quarterly reoccurring training tracker Windows 10 Quarterly reoccurring training tracker Office 2016
Novice
Quarterly reoccurring training tracker
 
Join Date: Jan 2020
Posts: 2
Paslay is on a distinguished road
Default

I believe it works!!!! thanks...
Reply With Quote
Reply

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
Quarterly reoccurring training tracker Calculating Quarterly Dates by Months not Days Artboy34 Excel 3 01-28-2016 09:47 AM
Quarterly reoccurring training tracker 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
Quarterly reoccurring training tracker Needs option to delete foward only when deleting reoccurring Peter Grono Outlook 1 02-19-2006 04:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft