There are plenty of things you can do, try conditional format with
this.

=AND(A1-TODAY()=0,A1-TODAY()<=30)

Or

Paste this into whatever cell, will returns days remaining from today
until the specified date code that is in the formula.

=DATEDIF(NOW(),38779,"d")

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=514597