hi
assuming the date is in A2, in B2, enter.....
=Today()-A2
format to general
or if you want to decimalize it.....
=Now()-A2
format to general.

Regards
FSt1

"Dianne W" wrote:

How do I create a formula using the date item was put into inventory and the
date you open to spreadsheet (every time) and figure the number of days in
inventory?