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.
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" <jeffcol777@discussions.microsoft.com> wrote in message
news:14F7CF20-D169-42D1-8D5F-B7C8064E3C44@microsoft.com...
>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.
(remove nothere from the email address if mailing direct)
"jeffcol777" <jeffcol777@discussions.microsoft.com> wrote in message
news:14F7CF20-D169-42D1-8D5F-B7C8064E3C44@microsoft.com...
> 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.
Question
Reply
Top
Answer
Notify me of replies