In cell D12, insert the function that will retrieve the date and time from your computer's calendar and clock.
Added by Tim A.
Step 1
Step 1: Click on cell D12 to select it. Show more…
Show all steps
Your feedback will help us improve your experience
Muhammad Jan and 81 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
how do you enter date and time in an Excel sheet
Muhammad J.
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.
Akash M.
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.
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