Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I know that if I place the following formula: =IF(A1="","",EDATE(A1,1)) in
cell B1 I will be able to obtain a date 1 month beyond the date I input in A1 (e.g. if A1= Sept 1, 2007, than the formula will result in the date Oct 1, 2008). What I'd like to know is how I can alter the formula to make the date outcome in B1 generate different than month out intervals (e.g. A1,2 would provide me with a two month out date, etc). An example of what I'd like to be able to generate is a date six weeks out, 3 weeks out, or at various other intervals. There are times when I'd even like to place to date to generate as "days out". Unfortunately I only seem to be able to create posting dates in one month intervals. Any help would be appreciated. Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) |