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.

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.

=TODAY()-A1 and then format as general or number.
--
Kevin Vaughn


"jeffcol777" wrote:

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.

=TODAY()-A1

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"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.