=IF(TODAY()-B16<90,0,INT((DATE(YEAR(B16),12,31)-B16)*0.0274)+0.5) This
formula works good except for one final thing! Since B16 is the actual start
date, and less than 90 days = 0 days accured, but 90 days = accural rate of
0.0274 up untill January 1 the following year, then it's 10 days. Here is my
problem... I can't figure out how to use the accural rate just untill January
1st rolls around then stopping accural time and changing results to 10.
Thanks so much! It is above and beyond me!!!