enter date(A) and have (B) total to current day?

J

jeffcol777

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

Paul B

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
 
B

Bob Phillips

=TODAY()-A1

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top