Yes!!! Thank you so much, Thats it!

"mr_teacher" wrote:


Does this do whatyou are after?

=IF(TODAY()-B16<90,0,IF(AND(TODAY()-B1690,TODAY()<DATE(YEAR(B16),12,31)),INT((DATE(YE AR(B16),12,31)-B16)*0.0274)+0.5,10))

Hope that helps?

Regards

Carl


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=571796