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 3 arguments dat e, n, k , where dat e is a date (e.g.,
TODAY() or DATE(2022,1,1)), n is the number of dates produced and k indicates how many
months apart the dates must be. Your LAMBDA formula starts like this LAMBDA(date,n,k,...)
and it will use somewhere the SEQUENCE function. Use your LAMBDA formula to compute
the deposit dates in your savings account calculator.
EDATE(given date, months) adds months to a date. It calculates a date k months after a given
date. For example, EDATE(1/1/2020,5) returns 6/1/2020.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!