... RECEIVED(settlement,maturity,investment,rate[,basis]) . RECEIVED calculates and returns the amount to be received at @maturity date for a security bond. @settlement is the settlement date of the security. @maturity is the maturity date of the security. ... 1 actual days/actual days . 2 actual days/360 . ... If @settlement date or @maturity date is not valid, RECEIVED returns #NUM! error. ... If @settlement date is after @maturity date or they are the same, RECEIVED returns #NUM! error. ...