| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formulas
Is there a way that I can put a general formula in multiple cells? I am
working woth dates and I am looking to make it so that as soon as I hit enter the computer adds 90 days to the previous cells date. Is this possible in any way? i.e. If A1 = 10-Jun-05 then A2 = 8-Sep-05 -- Buttaflye --They say home is where the heart is; then I wonder, where is my heart?-- |
|
#2
|
|||
|
|||
|
=sum(a1+90) -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=374534 |
|
#3
|
|||
|
|||
|
Will that work for all of the cells. That is, can I just put that in once
and it will work for cells A2 - A4 and the same for B, C, and D 1-4? -- Buttaflye --They say home is where the heart is; then I wonder, where is my heart?-- "keithl816" wrote: =sum(a1+90) -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=374534 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| Problem with named formula's | 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 | |||
Linear Mode
