Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a Date formula please?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a Date formula please?
Dan the Man wrote:
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 Hi Dan, Why not just add intervals of 7 to A1? = Today() + (6*7) yields 29-Sep-2008, which is correct on my calendar. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a Date formula please?
hi
try a different formula. with a date in g5... =DATE(YEAR(G5),MONTH(G5),DAY(G5)+14) this will add 14 days(2 weeks) to the date in g5. alter cell reference and days out as needed. Regards FSt1 "Dan the Man" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a Date formula please?
Thanks very much for the help. That did the trick. I love this
group...................Dan "FSt1" wrote: hi try a different formula. with a date in g5... =DATE(YEAR(G5),MONTH(G5),DAY(G5)+14) this will add 14 days(2 weeks) to the date in g5. alter cell reference and days out as needed. Regards FSt1 "Dan the Man" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a Date formula please?
For a number of days, =G5+14 is easier. :-)
[Of course, for months or years, your method makes sense.] -- David Biddulph "FSt1" wrote in message ... hi try a different formula. with a date in g5... =DATE(YEAR(G5),MONTH(G5),DAY(G5)+14) this will add 14 days(2 weeks) to the date in g5. alter cell reference and days out as needed. Regards FSt1 "Dan the Man" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |