Training Update Formula

[tim677]

I have the following formula
=IF(V9+365>P3,AB1,AB2)
V9 = the cell a date is typed in
P3 is using =NOW() function
AB1 = 1
AB2 = 2
This sheet will be used to identify if training requires updating annually (1) meaning in date and (2) meaning out of date. I am looking to introduce (3) to alert the manager a month before the training is out of date, how would I introduce a 3rd function into a TRUE/FALSE formula?
Any ideas?

Thanks

 

[texasalynn]

Welcome to MrExcel board....

does this work

Excel Workbook
	P	Q	R	S	T	U	V
3	3/11/2011
4
5
6
7
8
9							4/12/2010
10
11							TRUE
Sheet1

Excel 2003

Cell Formulas
Range	Formula
P3	=NOW()
V11	=IF(DATEDIF(P3,V9+365,"YM")>=1,TRUE,FALSE)