thanks, Paul....but that formula returns the # 26 with or without today() in field a1.

could you step me through it so I understand what it's doing, and figure out where to adjust it?