bustos1juan
New member
- Joined
- Mar 21, 2019
- Messages
- 7
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
[FONT="]Hello dear excel professionalteam,[/FONT]
[FONT="]I would like to get some help on solving an issue that I cannotfigure it out.[/FONT]
[FONT="]I am building a sheet and I would like to identify the due datefor training having the frequency as my identifier for the due date. I meant,if "Bart" got the Fire training on 05/10/2016 and the traininghave a "Frequency" set up as "Every 3 years" I would likethat the column in "Due date" identify when is the date set up forthe next training as per the frequency defined in the Column"Frequency".[/FONT]
[FONT="]I am providing my example attached. I have 5colums:
Column WORKER (people that will take a training)
Column TRAINING (The training available)
Column START (When the training was taken first time)
Column FREQUENCY (How often the training must be taken)
Colum DUE (When the training must be taken once again)
Each training has a frequency (Initial, Annually, Every 2 years and Every 3years) I would like to set up the due date column considering the frequencyrequired for each training.
I hope you are kind on helping me with this issue.
Best regards
Jhon[/FONT]
[FONT="]I would like to get some help on solving an issue that I cannotfigure it out.[/FONT]
[FONT="]I am building a sheet and I would like to identify the due datefor training having the frequency as my identifier for the due date. I meant,if "Bart" got the Fire training on 05/10/2016 and the traininghave a "Frequency" set up as "Every 3 years" I would likethat the column in "Due date" identify when is the date set up forthe next training as per the frequency defined in the Column"Frequency".[/FONT]
[FONT="]I am providing my example attached. I have 5colums:
Column WORKER (people that will take a training)
Column TRAINING (The training available)
Column START (When the training was taken first time)
Column FREQUENCY (How often the training must be taken)
Colum DUE (When the training must be taken once again)
Each training has a frequency (Initial, Annually, Every 2 years and Every 3years) I would like to set up the due date column considering the frequencyrequired for each training.
I hope you are kind on helping me with this issue.
Best regards
Jhon[/FONT]