Richard wrote:
B16 is formatted as a date and never changes, Example 7/31/06, If
TODAYS DATE is 1/1/2011 or greater then 4


Hi Richard,
try this:

=IF(YEAR(TODAY())-YEAR(B16)5,4,IF(AND(B16=DATE(YEAR(B16),1,1),B16< =DATE(YEAR(B16),6,30)),3,IF(AND(B16=DATE(YEAR(B16 ),7,1),B16<=DATE(YEAR(B16),9,30)),2,IF(AND(B16=DA TE(YEAR(B16),10,1),B16<=DATE(YEAR(B16),12,31)),0," "))))


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy