put forumla =now() in another cell (this will always
calculate todays date)
in your forumla column put
=DATEDIF(A2,$B$2,"d")
where a2 is the cell with the original date and b2 is the cell with
now() in.
R
--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile:
http://www.excelforum.com/member.php...o&userid=24503
View this thread:
http://www.excelforum.com/showthread...hreadid=388066