Calculate Total Months Between Based On Different Inputs

[Soch10]

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!

[AliGW]

Administrative Note:

Welcome to the forum.

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

[AliGW]

How about this?

=IF(OR([@[F1 Evaluation Pass / Fail]]="Pass",[@[F1 Evaluation Refire Date]]="Pass"),DATEDIF(D3,[@[Actual F1 Evaluation Date]],"M"),DATEDIF(D3,TODAY(),"M"))

Excel can't just stop counting without another date to use where the criteria ar e met.

[Soch10]

Thanks for that! I believe I added the correct information.

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.