![ally6440](/avatars/16089.jpg)
ally6440
28.11.2019 •
Computers and Technology
In cell c11, enter a formula to reference the date stored in cell b7. insert a nested function in cell c12 to calculate the date for the next payment. nest the year, month, and day functions within the date function. add 1 to the month result. copy the function to the range c13: c34.
Solved
Show answers
More tips
- F Food and Cooking Choosing the Best Water Filter: Tips and Recommendations...
- H Health and Medicine How Much Does Abortion Cost? Expert Answers and Insights...
- H Health and Medicine Contraceptive Pills After 35: The Importance Of Choosing The Right Medication...
- C Computers and Internet How to Set Up Internet on iPhone? Detailed Guide with Step-by-Step Instructions...
- P Philosophy 8 привычек, чтобы достичь счастливой жизни...
- F Food and Cooking How Many Grams Are In a Tablespoon?...
- G Goods and services How to Choose the Right Iron: Purchase Tips...
- S Style and Beauty How to Choose the Perfect Hair Straightener?...
- H Health and Medicine How to Choose the Right Glasses?...
- H Health and Medicine What vaccines do children need?...
Answers on questions: Computers and Technology
- C Computers and Technology In normal view, powerpoint s contains buttons such as notes, comments, and view....
- S Social Studies In which type of government do the citizens of the country have the most power?? (use complete sentences) Does it matter? Why or Why not?...
- P Physics Cual es la fórmula que describe el movimiento rectilíneo uniforme, definiendo variables y anotando las unidades en los sistemas SI, cgs y FPS?...
- H History Which of the following is not an example of human geography? a geographer studies the social organization of a small village in italy. a team of geographers examine the interactions...
- M Mathematics Six oranges cost 5.34 how much does it cost for one orange...
Ответ:
=B7 to be placed at c11. And the nested function at c12 is
=DATE(YEAR(B7),MONTH(B7)+1,DAY(B7))
And to copy the function to the range c13:c34 copy c12 and drag the cursor to c34 and press enter. Each cell will then show the date with month incremented by 1 each time.
Explanation:
=B7 to be placed at c11. And the nested function at c12 is
=DATE(YEAR(B7),MONTH(B7)+1,DAY(B7))
And to copy the function to the range c13:c34 copy c12 and drag the cursor to c34 and press enter. Each cell will then show the date with month incremented by 1 each time.
Remember, for nesting date function, we need to provide the arguments year, month and day to the date function. Year at B7 is YEAR(B7), Month is MONTH(B7), Day is DAY(B7). And we need to increment the Month by 1. And thus the above formula.
For referencing to another cell which is B7, we need to write =B7 at c11.
Ответ: