Hi Everyone,
I have attached the file that I am currently working on building. I need to be able to calculate someone's months in training if they are still in training based on their entry date and completion date. But I want to see the total months in training if they have not yet completed that training.
In the excel sheet that I attached, I want to see Column F (Months in Training(F1)) continue to count from Column D (Date Entered Training), until I change Column I to a "Pass". If Column I is a "Fail" I want Column F to continue counting until Column K is either marked "Pass" or "Fail".
I hope someone can help me!
Bookmarks