jeffcol777, =TODAY()-A1 format the cell as general
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"jeffcol777" wrote in message
...
I want to figure out how to enter a date in column A and have column B give
me a total number of days to the current date. Example, column A entry
1/21/06, with the current date being 2/2/06, have the result of column B
be
12.