Question

In column H, Jayden wants to display how long the plants have been in inventory, which is the number of days between the current date and the in-stock date. In cell H5, insert a formula without using a function that subtracts the in-stock date (cell G5) from the current date (cell B3). Use an absolute reference to cell B3 in the formula. Fill the range H6:H15 with the formula in cell H5, filling the range without formatting.

Name: in column h jayden wants to display how long the plants have been in inventory which is the number of days between the current date and the in stock date in cell h5 insert a formula without 94981
Uploaded: 2023-09-11T03:10:44-08:00
Duration: 2 min 20 s
Channel: Akash M
Description: in column h jayden wants to display how long the plants have been in inventory which is the number of days between the current date and the in stock date in cell h5 insert a formula without 94981

          In column H, Jayden wants to display how long the plants have been in inventory, which is the number of days between the current date and the in-stock date. In cell H5, insert a formula without using a function that subtracts the in-stock date (cell G5) from the current date (cell B3). Use an absolute reference to cell B3 in the formula. Fill the range H6:H15 with the formula in cell H5, filling the range without formatting.

Added by Matthew H.

Horngren’s Cost Accounting

Srikant M. Datar, Madhav V. Rajan 16th Edition

Instant Answer

Solved by Expert Akash M

09/11/2023

Step 1

First, click on cell H5. Show more…

Show all steps

Thanks for your feedback!

In column H, Jayden wants to display how long the plants have been in inventory, which is the number of days between the current date and the in-stock date. In cell H5, insert a formula without using a function that subtracts the in-stock date (cell G5) from the current date (cell B3). Use an absolute reference to cell B3 in the formula. Fill the range H6:H15 with the formula in cell H5, filling the range without formatting.