The AMORDEGRC The function uses the following syntax:
AMORDEGRC (cost, date of purchase, first period, Recovery, period, rate, [basis])
Important: Dates must be entered using the DATE function, or as a consequence of other formulas or functions. As an example, use DATE (2016,5,23) For the day 23 May 2016. Problems can arise if dates are entered as text.