Hi,

I'm building a log of when training has been completed for employees and I want a formula so that the due date field will automatically be filled in once the last completed training date has been entered.

For example, an employee completes a Proficiency Check (PC) on 2014-02-14... the due date for that is the first day of the 14th month, so in this case, 2015-04-01.

I can't find a good formula to do that, any ideas?

Secondly, I want to have the 11th month shown in green, the 12th month shown in amber, and the 13th month shown in red. So in the above example, for the entire month of Jan 2015 the color of the due date (2015-04-01) will be green, then for the entire month of Feb 2015 the color will be amber, and for the entire month of Mar 2015 it will be red.

Is it possible to do that?

Thanks very much for your time!

4fifty8