Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto calculate for date + days forward to yield new date
Would like the formula to calculate this: in Column B, I have dates, such as
10/14/2005, 1/21/2006. In rows C2 through I2, I have whole numbers such as 10, 25, 38, 50. In row C4 through I4, I would like the spreadsheet to automatically calculate the date of Col B + C2, for example, so that the any number I add to the existing dates in Column B will show the correct date (such as existing date in Col B + 45 days = new date of ?) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto calculate for date + days forward to yield new date
If you have a date in A1 and a number in C1 and you want B1 to show the date
of A1 plus C1 number of days, do this: In B1: =A1+C1 HTH Otto "John Sullivan" wrote in message ... Would like the formula to calculate this: in Column B, I have dates, such as 10/14/2005, 1/21/2006. In rows C2 through I2, I have whole numbers such as 10, 25, 38, 50. In row C4 through I4, I would like the spreadsheet to automatically calculate the date of Col B + C2, for example, so that the any number I add to the existing dates in Column B will show the correct date (such as existing date in Col B + 45 days = new date of ?) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Start Dates based on Need-By Date? | Excel Worksheet Functions | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
calculate the number of days from date received | Excel Worksheet Functions | |||
how to calculate a date .. say 34 days from today | Excel Discussion (Misc queries) | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |