add days to a date and return resulting date
With date in A1 and discount period in A2.
=A1+A2
If the discount period includes the stated date
=A1+A2-1
--
Ian
--
"LKONITZ" wrote in message
...
i'M GIVEN A DISCOUNT PERIOD IN DAYS AND THE ORIGINAL DATE OF THE NOTE AND
WOULD LIKE TO KNOW WHAT THE RESULTING DATE (AFTER THE DAYS ARE ADDED) IS.
|