Thread: Quarterly reoccurring training tracker
View Single Post
 
Old 01-06-2020, 01:05 PM
NBVC's Avatar
NBVC NBVC is offline Windows 10 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