Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Continuous Formulas
I am working with dates, and I am wondering if there is a standard formula
that I can enter. What I am looking to do is have 4 horizontal rows take one formula and one block on the horizontal line to take another. (The four I want to add 90 days to the date and the one I want to add 270). Please help!!! -- Buttaflye --They say home is where the heart is; then I wonder, where is my heart?-- |
#2
|
|||
|
|||
Buttaflye,
Your question is a bit (or more) confusing. Could you post an example of what you have, and what you want? HTH, Bernie MS Excel MVP "Kulakula" wrote in message ... I am working with dates, and I am wondering if there is a standard formula that I can enter. What I am looking to do is have 4 horizontal rows take one formula and one block on the horizontal line to take another. (The four I want to add 90 days to the date and the one I want to add 270). Please help!!! -- Buttaflye --They say home is where the heart is; then I wonder, where is my heart?-- |
#3
|
|||
|
|||
If A1= 7-Mar-05I want to put a formula in for A2, A3, and A4 to add 90 days;
this way I have a new date as soon as I hit enter. I would like for this to happen with B1-4,C1-4, and so on all the way to Y. For A5 I am looking to add 270 days; this I would like to do with all of the 5 colums as well. -- Buttaflye --They say home is where the heart is; then I wonder, where is my heart?-- "Barb R." wrote: Please clarify how you want this to look: Let's say you have A1 = 5/25/2005 What do you want in A2, A3, A4, etc.? "Kulakula" wrote: I am working with dates, and I am wondering if there is a standard formula that I can enter. What I am looking to do is have 4 horizontal rows take one formula and one block on the horizontal line to take another. (The four I want to add 90 days to the date and the one I want to add 270). Please help!!! -- Buttaflye --They say home is where the heart is; then I wonder, where is my heart?-- |
#4
|
|||
|
|||
Please clarify how you want this to look:
Let's say you have A1 = 5/25/2005 What do you want in A2, A3, A4, etc.? "Kulakula" wrote: I am working with dates, and I am wondering if there is a standard formula that I can enter. What I am looking to do is have 4 horizontal rows take one formula and one block on the horizontal line to take another. (The four I want to add 90 days to the date and the one I want to add 270). Please help!!! -- Buttaflye --They say home is where the heart is; then I wonder, where is my heart?-- |
#5
|
|||
|
|||
I am working with dates, and I am wondering if there is a standard
formula that I can enter. What I am looking to do is have 4 horizontal rows take one formula and one block on the horizontal line to take another. (The four I want to add 90 days to the date and the one I want to add 270). Please help!!! It's helpful to realize that Excel stores a date internally as an integer (starting 1/1/1900). So to do what you want, just add 90 or 270 or whatever, then format the result as a date. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |