Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add days to a date and return resulting date
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add days to a date and return resulting date
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add days to a date and return resulting date
Read a book on Excel. It will probably explain to you that dates are just
numbers. Tyro "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |