add days to a date and return resulting date

  • Thread starter Thread starter LKONITZ
  • Start date Start date
L

LKONITZ

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.
 
With date in A1 and discount period in A2.

=A1+A2

If the discount period includes the stated date

=A1+A2-1
 
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
 
Please drop the ALL CAPS.......hard on the ears and eyes.

Original date in A1

Number of days in B1

Resulting date in C1 =A1+B1 ...........formatted as date.

Or more simply =A1+number...........skip the middle man.


Gord Dibben MS Excel MVP
 
Back
Top