Enter the correct formula for cell H3 that calculates the years of services the date in cell C1 and G3 to calculate the number of days the divide by 360 to get the years. Use absolute addressing when referencing todays date.
Added by Kathleen H.
Step 1
Step 1: Calculate the number of days between the date in cell C1 and today's date. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 70 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
In cell E5, enter a formula to calculate the number of days for the first workshop. Add 1 to the result to include the total number of days, including the start and end dates. The result may display in date format. Copy the formula to the range E6:E10.
Akash M.
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.
Supreeta N.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD