date calculation

S

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
 
F

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
 
R

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
Click to expand...

Entering "sum" is unnecessary.

=today()-Date_Entered


--ron
 
Top