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

On Sat, 19 Apr 2008 12:01:00 -0700, LKONITZ
wrote:

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.