View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B[_2_] Kevin B[_2_] is offline
external usenet poster
 
Posts: 4
Default How many days since....

Put following formula in B1 to subtract the date in A1 from the current
system date.

=TODAY()-A1

"Jim" wrote:

I would like to ask for help with a formula:

If I have a date in A1 (4/10/09) and in B1 I want a formula that shows how
many days has passed since that date, how would I write this formula?



Thanks
Jim