date calculation

[steveb1]

I am using excel for a inventory list and need to track the number o
days an item has been in-stock. How can I create a formula to show m
the number of days from the date entered to today's current date

 

[Don Guillett]

try
=today()-e8 formatted as a number
or datedif
=DATEDIF(E8,TODAY(),"d")

 

[Frank Stone]

if your Date Entered was j5 then
=sum(now()- J5
or
=sum(Date-J5)
Now() = mm:dd:yy hh:mm:ss
Date = mm:dd:yy

 

[Ron Rosenfeld]

if your Date Entered was j5 then
=sum(now()- J5
or
=sum(Date-J5)
Now() = mm:dd:yy hh:mm:ss
Date = mm:dd:yy

Entering "sum" is unnecessary.

=today()-Date_Entered


--ron