date functions
 

i am trying to track the number of days a product has been in storage. i
need this to be an automatic update. Example: product 1 has been in storage
3 days. when i open worksheet tommorrow i need it to change to 4 days. wht
formula do i use

date functions
 

try

=TODAY() - [the date it went into storage]

Bob

"meeric" wrote:

i am trying to track the number of days a product has been in storage. i
need this to be an automatic update. Example: product 1 has been in storage
3 days. when i open worksheet tommorrow i need it to change to 4 days. wht
formula do i use