View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_344_] Rick Rothstein \(MVP - VB\)[_344_] is offline
external usenet poster
 
Posts: 1
Default add days to a date and return resulting date

In the future, do not use all upper case letters for your messages... it is
hard to read.

To answer your question... just add them. Dates are really just numbers (an
offset from 1/1/1900) formatted to look like a date. So, if your date is in
A1 and your days to add are in B1, the formula to get the new date is...

=A1+B1

Rick


"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.