Well of course had I closed the application and reopened it and used my
brain. Thank you so much for all the help. It seems to work like a charm.
I will try it on the main sheet and see what happens. This has been very
helpful.

"daddylonglegs" wrote:


Is that not correct? You wanted the days remaining. If it shows 1745
today it will show 1744 tomorrow and so on until it reaches zero on
31st December 2010.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=524789