View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian Ian is offline
external usenet poster
 
Posts: 238
Default 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.