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
|
|||
|
|||
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
|
|||
|
|||
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 |