+ Reply to Thread
Results 1 to 2 of 2

Looking for conditioned continuing education tracker

  1. #1
    Registered User
    Join Date
    10-30-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2010
    Posts
    36

    Looking for conditioned continuing education tracker

    I am hoping a spreadsheet like what I am looking for has already been created and I am just not finding it. I am looking to track education workshop criteria based on a condition. For example, I need the person to be completed from the training program with in one year of start date and have lead a workshop at least once a year after completion of the class to remain active. Then there is a second level that says they must have completed the training, and held 2 workshops in the first year then one workshop every other year to remain active.

    Can anyone direct me to a spreadsheet like that that was already created so I can look at the formulas?

    Currently I have the formula written as if today is less than the anniversary date, then Active, if not then #workshops completed must be greater than 1, if not then inactive. The problem with this is it doesn't account for year 3 ect.... (looks at a second sheet that tracks when all workshops are held and counts how many workshops each leader taught).

    for the second level, I have if today is less than anniversary date then active, if not # of workshops completed must be greater than 2, but again it doesnt take into account year 3.

    THanks!

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Looking for conditioned continuing education tracker

    Why don't you Google for your question.
    That will get you answers
    Google "excel tracking template" and you will get many hits, I'm sure there will be one there for you.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel education
    By Wikster7 in forum The Water Cooler
    Replies: 3
    Last Post: 01-21-2016, 02:23 PM
  2. Excel education
    By Wikster7 in forum Excel General
    Replies: 1
    Last Post: 01-13-2016, 03:56 PM
  3. Help build a Leave tracker and Effort Time Estimation Tracker
    By cherias in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2015, 02:10 PM
  4. Education
    By MichaelGG1581 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-11-2015, 12:11 PM
  5. System idle time tracker / Break Tracker
    By reetika05 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-10-2014, 07:26 AM
  6. time tracker-a running tracker date wise
    By arnab0711 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2008, 03:08 PM
  7. Help save my education!
    By Hodges1 in forum Excel General
    Replies: 1
    Last Post: 04-08-2005, 12:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1