View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default enter date(A) and have (B) total to current day?

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