how do i create an excel formula to work out a date x amount of w.
how do i create an excel formula to work out a date x amount of weeks ahead
from a given date. ie
Start date 1/10/04 Contract Duration 27 weeks Result date?
This is what i am trying to acheive, any help would be appreciated.
With date in A2
(When sending e-mail, use address arvil<At>tarkon.ee)
"Ska" <Ska@discussions.microsoft.com> wrote in message
> how do i create an excel formula to work out a date x amount of weeks
> from a given date. ie
> Start ...Where does Excel store the orientation of PivotFields?
I'm trying to find out where Excel stores the orientation of a PivotField,
especially once it has been draged into position.
Right now I'm using the
AcitveChart.PivotLayout.PivotTable("TableName").PivotFields() Function to get
a collection of all Fields within that Table. But even though all Fields are
in the collection each of them has the orientation "xlHidden" regardless
where I dragged them at the chart. The display of the fields within the
charts works perfectly fine.
Can Somebody Help me please?
...Excel 2010 Object Model
In the online help, the Excel Object Model is not in a usable visual format.
Is the Excel 2010 Object Model available in PDF or other image format?
...Get Access Data into Excel
I am using excel macro to get data from access database.
My sql query gives me 5 records or more than that.
I am able to pull it different cells.
But I want all the 5 results in single cell.
im not exactly sure what your trying to do, but maybe something like this
will do the trick
dim accval as string
accval=accval & " " & rs!:xxx
loop it till rs.eof=true
> Hi All,
> I am using excel macro to get data from access database.
>...Printing a worksheet in two (or more) columns
I've got an extremely long spreadsheet table comprising two columns of data.
I'd like to print these data in a more compact form - in the same way that
the entries are organised in a telephone directory.
Say on average my page is 50 rows high - my first two columns on page 1
would appear on the left hand side and be rows 1 through 50, row 51 would
continue at the top of the page, but on the right-hand side. Row 101 would
appear at the top left hand side of page 2, etc.
I'd like to keep the orientation of the columns in portrait (I did find a
printer-associ...how can i relate between two columns in two sheets?
Question no too clear - you can use this space to give a detailed question.
But here goes:
On Sheet1 I can type formulas such as
If I type = and then click on the cell A1 of a worksheet called My Yearly
Totals, I will get the formula
='My Yearly Totals'!A1
Note that a sheet name having spaces get surrounded by single quotes.
Does this answer your question?
Microsoft Excel MVP
email address: remove uppercase characters
REMEMBER: Microsoft is closing the newsgroups; We will all me...How to determine the area under a curve (integration) in Excel?
I would like to compare the areas under curves in a chart.
How to determine the area under a curve (integration) in Excel?
Have a look at Bernard Liengme's page.
> I would like to compare the areas under curves in a chart.
> How to determine the area under a curve (integration) in Excel?
We have a spreadsheet that was set up to link to a database via a
system DSN. To simplify deployment of this, I'd like to change this
to connect via the connection string below:
I've done this for another spreadsheet, and it was easy (Data tab-
>Connections->Properties), but in this next spreadsheet the Connection
Properties for one connection are greyed out/disabled, so I can't
change the string.
Does anyone have any ideas how to enable these values again so I can
change the connection string?
...Formula causing run-time error in Excel Programming
This is a repost.
I have the following line of code that I am trying to drop in a cell via
Access VBA but I keep getting a Run-time error 1004, Application-defined or
xls.cells(Rw, Col + lngColumn).value =
& lngColumn + 1 & "),--(ET_Raw_Data!$D$2:ET_Raw_Data!$D$20000='Feature
I already have 2 other formulas that are being add...Excel 2002 is scrolling to the very bottom of my spreadsheet
When I open Excel 2002 my spreadsheets are scrolling to the bottom by itself.
If I move it back to the begining it scrolls back to the end. What is going
Perhaps Speech Recognition is turned on. It can cause some strange
Choose Tools>Speech>Speech Recognition
(if it had a check mark, it was turned on)
> When I open Excel 2002 my spreadsheets are scrolling to the bottom by itself.
> If I move it back to the begining it scrolls back to the end. What is going
Excel FAQ, Tips & Book List
http://www.contexture...Formatting hyperlinks in an Excel cell 02-16-10
Two of the columns in a spreadsheet (Excel 2003) that I use record email and
All of them appear as hyperlinks i.e. blue and underlined but some
occasionally seem to lose their hyperlink properties. This means that when
one hovers over them, the cursor stays as the usual Excel cross rather than
changing to the hand/finger symbol. Also, clicking on the former does not
launch the browser.
Is there any way to ensure they are formatted, and work, as hyperlinks
...Import and Export from/to Excel query
I need to import and export Excel files in and out of Outlook 2003. When I
try and do it I am told I don't have the correct translator and do I want
to install it - when I say yes it tells me to put in the CD - when I put in
the CD it doesn't install but just freezes up and I have to cancel - the
file it tells me I need is L4561403.CAB
How and where do I install L4561403.CAB which I assume that I can find on
TIA for any help.
KiwiBrian <firstname.lastname@example.org> wrote:
> I need to import and export Excel files in and out of Outlook 2003.
> When ...Losing all formatting in Excel 2007 files
I have Office 2007 running on an XP desktop and a Windows 7 laptop. I work
on an Excel .xlsx file on my desktop but when I open it on my laptop all of
the formatting is lost.
I have had this exact same problem except vista to xp. I wouldn't lose all
of the formatting, but some words would would be on different lines. Other
things I have noticed is that my Office 2007 on Vista doesn't always have the
same fonts as on my Office 2007 XP. I think the formatting issue is more of a
...Parse multiple text lines into 1 line in excel
help. I am an excel beginner and can't find out how to turn multipl
lines of text into 1 row in excel. It's probably really easy but m
manual is USELESS. Can anyone help
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
You're a little short on details. If nothing below fits the bill post back.
"Multiple lines" is how many and is each line in a separate cell down one
Do you want all lines to go into one cell?
You can use this form...refer to data on multiple worksheets using hlookup/look up data on many worksheets?
I have data on many worksheets in the same workbook.
Is it possible to look up data on multiple worksheets using Hlookup,
which means can the second argument in the formula refer to multiple
If it is not possible, is there any other way I can do so?
I would like to select and display data according to a fixed order,
whereby the data is located in one of many worksheets in the same
For eg, I have stock returns of many firms in many worksheets. Say I
would like to display in a single worksheet the returns of Firm D, Firm
Z, Firm R; whereby the data of these 3 fir...Conditional Formatting with Relative Reference.
Conditional Formatting with Relative Reference.
A B C D E F
1. 4.5 6 7.4 8.3 10 2
2. 1 2 3 4 3 2
3. 1 2 3 4 5 6
4. 6 5 4 3 2 1
How can Excel 2003 workbook be designed so that if a value of a cell is
smaller or greater than the value of the cell, then color of the cell is
auto formatted ?
Formatting of the cell is as follows: Green if value is greater and Red if
...Can you program Excel to draw an asymptote?
I want to know if there is a way to get excel to put an asymptote on a chart
if you already have a parabolic data set on the chart. My goal is to find to
value of the asymptote for further analysis. I know I can fudge a straight
line graph onto the chart but it is not meaningful without the true value.
"csusbgirl07" <email@example.com> schrieb im
> I want to know if there is a way to get excel to put an asymptote on
> if you already have a parabolic data set ...When launching Excel 2007 the VB debuger always opens
I am testing Excel 2007 Beta 2 on two computers.
On one of them, XP SP2 there is no problem. On the other, 2003 Server SP1,
each time I open Excel a VB window opens up, with a message that says
"Compile error: Cant find project or library."
If I close that window I get a message saying that the debugger will stop.
If I close that, Excel reacts normally.
Do you have any templates loading on the second computer?
What is shown in VB itself when you see the error message? Which module
are you in?
This sounds like...how do I apply more than 3 conditional formats in excel
I want to create a themal analysis problem whereby the results of the
calculation are displayed in a grid of cells (representing the shape of the
item). I then want to apply conditional formatting which colours the cells
depending on the value. I want there to be 10 colours ranges. I can do this
easily for four colours using standard conditional formatting but I want to
use 10 colours, is there a way to expand the conditional formatting?
couple of options - there's a conditional formatting add-in available for
or you...Hyperlink powerpoint object to excel range?
I'm using a powerpoint presentation to show several ranges on several
worksheets in an excel workbook.
No problem linking the excel file to powerpoint but is there a way to link
powerpoint to a range address within that file?
I am hoping to flip back and forth with several powerpoint links to
particular worksheet ranges.
Your advice will be appreciated
...Excel.Application User-define Error
In trying to solve a Access to Excel data linking problem from Microsoft's
I am trying to run the example and it dies on
Dim xlApp As Excel.ApplicationThe error message I get is "Compile error:
User-defined type not defined." Is there something I need to add like a
reference in order to get this to work?Mike
You need to add a reference to Excel (through Tools | References while in
the VB Editor).
Personally, I prefer using Late Binding, since setting a reference then
limits your application to only those users with the same ...Type mismatch error in Excel
I receive a type-mismatch error when compiling. The cells being
referenced only have dates. Can someone help? Heres some of the code
a = Range("D:J")
b = DateValue(Format(Now(), "mm-dd-yyyy")) - Weekday(Now(), 1)
c = Application.VLookup(b, a, 2, False) "This is where the ERROR-13
'Tpye Mismatch occurs'
The default property for a range is the .Value property, so
a = Range("D:J") is returning an array of values, not a range object.
Try something like:
Dim a As Range
D...CSV formatted text file to Excel
I am writing a small VC++ application of how to import the CSV
..txt file to excel. I am facing problem while parsing the text file.
12534 , 763534 , 23
12345 , 624333, 24
The problem is in MFC there is a SetValue2(CoeVariant:column data)
method in which if i will pass an array(12534) then it will be
imported to excel.For example IfI will search for the "employee
number" field in text file then the values passed to SetValue2()should
be 12543 and 12345.But Using C++ I cannot do so as I...WHAT DOES THE SYMBOL"$" REPRESENT IN A EXCEL FORMULA?
SORRY FOR THE NOVICE EXCEL QUESTION - IM JUST LEARNING THE PROGRAM AND CANT
SEEM TO FIND IN "HELP" ALL SYMBOLS FOR FORMULAS
It's used to create an absolute cell reference, i.e. one that will not be
changed even when the formual is copied and pasted.
Without the the $ symbol, a formula such as =A1+B1 in cell C1 would be
changed to =A2+C2 if it was copied into cell C2, whilst this is useful if
you're creating a table of information, it can some times be a pain.
By changing the original formula to =$A$1+$B$1, it will not change when
The above example keeps it en...opening excel worksheet
Operating System: Mac OS X 10.6 (Snow Leopard)
whenever I try to open an existing excel worksheet it opens very short. I have to drag it down to the bottom of the screen, is there a setting that i need to adjust?
No, simply SAVE the workbook after you adjust it.
Next time, it will open at the size you want.
On 27/03/10 6:42 AM, in article 59bb6065.-1@webcrossing.JaKIaxP2ac0,
"firstname.lastname@example.org" <email@example.com> wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel