Question: Use EDATE ( ) or DATE ( ) to fill in the Deposit Date column. Write a LAMBDA formula which takes 3 arguments dat e
Use EDATE or DATE to fill in the Deposit Date column.
Write a LAMBDA formula which takes arguments dat e n k where dat e is a date eg
TODAY or DATE n is the number of dates produced and k indicates how many
months apart the dates must be Your LAMBDA formula starts like this LAMBDAdatenk
and it will use somewhere the SEQUENCE function. Use your LAMBDA formula to compute
the deposit dates in your savings account calculator.
EDATEgiven date, months adds months to a date. It calculates a date k months after a given
date. For example, EDATE returns
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
