Formula adding 2 days...
So, here is the formula I'm using. Some cells it's adding 2 or 3 days to the
MONTH and some cells it's not. I don't WANT it to add 2 days. It should just
be adding 5 years and leaving the month and day the same... what is happening
Never mind!!! I'm ridiculous! I figured it out!!!!
> So, here is the formula I'm using. Some cells it's adding 2 or 3 days to the
> MONTH and some cells it's not. I don't WANT it to add 2 days. It should just...Stacked column chart wit more than one column in a data point
My colleague has the following data.
A Sales Growth,5%,11%,12%,3%,10%,7%,4%,4%
A Comps Growth,5%,7%,5%,4%,2%,8%,6%,4%
B Sales Growth,3%,4%,6%,4%,5%,5%,3%,3%
B Comps Growth,8%,10%,11%,4%,6%,5%,10%,7%
C Sales Growth,1%,1%,3%,4%,6%,4%,1%,2%
C Comps Growth,10%,7%,5%,6%,2%,5%,6%,5%
and he wants to plot charts in such a way that the years 1998 through
2005 comes in x-axis and within each year there needs to be 3 data
points for companies A, B and C.
The particular data point for 1999 and for company A need to be of
Stacked column chart type with its...having trouble creating chart to show monthly totals
I'm using office XP.
I keep a single spreadsheet were I record orders received.
Its a very simple sheet with one order per row.
In col B I place the date the order was received (in the format DD/MM/YY)
I'd like to make a chart (pie or column) which displays the total number of
orders per month so that I can see at a glance when were busy and quieter
I've tried using the wizard but all I ever get is a mess and not what I
expect to see at all.
I suspect I may need to separate my data by month? But is there a way for
Excel to work that out for itself from a sin...Is it possible
I would like to know is it possible to make million dollar in the internet, if you have any suggestions, write on my forumhttp://isitpossible.truemillion.comMark...Personal Folders in OWA
I have just enabled OWA on our Exchange 2003 SP2
through ISA Server 2004. Is there any way to
access personal folders in OWA?
Thanks in advance.
If by personal folders you mean .pst files, the answer is NO! Sorry.
C C wrote:
> I have just enabled OWA on our Exchange 2003 SP2
> through ISA Server 2004. Is there any way to
> access personal folders in OWA?
> Thanks in advance.
"C C" <email@example.com> wrote:
>I have just enabled OWA on our Exchange 2003 SP2
>through ISA Server 2004. Is there any way...How to keep rotated clip art from being cut off?
Whenever I rotate clip art (from any source) it is often cut off around the
edges. If zero rotation, image is complete. What's the secret?
There is no secret. What do you mean "cut off?" Are you manually rotating or using
the "format object" dialog?
It could be your graphics driver. Slide the acceleration down on your adapter,
control panel, display folder, settings tab, advanced button, troubleshoot tab. If
this helps go to the manufacturer's web site of your graphics card and look around
for an updated driver.
Mary Sauer MSFT MVP
http://office.microsoft...is this possible? reload a form that is based on a query with new query that is defined in the form.
I have a basic form.
The form is based on a query, so when I open the form, a pop comes up
where I enter in what I want to query.
So instead of 30,0000 records, I get 1-10 records.
on the form, I have a text box. I want to be able to enter in what I
want to query next and afterupdate have the recordset/form reload with
that query instead of my original qeury.
I figure this has to be done with VB. I am just starting to learn some
VB but I am lost.
Any info would be great, thank you.
You need to apply the new query or table name, or the sql string to
the forms recordsource, then...Downloading Statements Directly Not Possible
I have Money 2002 installed on an Win XP Pro SP1 machine. Something
happened and I probably did it, that causes the statement downloads not to
go directly to the account. Rather they want to be saved in a file and then
opened into Money. I then have to delete the download.
I have tried several things in order to fix this:
1. I verified the file associations of OFC, OFX were correct. They were.
2. Lowered all my security settings in IE. Even put banks into Trusted site
zone. No go.
3. Made new accounts. Didn't help.
4. My IE cache is large (500MB) and regularly cleaned out.
5. I made s...Moving an old transaction from one account to another.
I have a *very* strange situation here...
Once upon a time, Mr. Pat Smith married Ms. Pat Jones. The Mrs. Pat Smith
was a cute oddity for the duration of the marriage. Sadly, the marriage
ended. Mrs. Smith did not change her last name back to Jones...
Now we have two people in town with the same name. 'Pat Smith'. Mr. Pat
Smith bought a mattress set. In RMS, the mattress is on Mrs. Pat Smith's
account. This probably would have gone unnoticed for along time, possibly
forever, except for the unfortunate demise of the mattress under warranty.
Now we need to return the m...Copy a chart from one workbook to another workbook?
l've tried to copy one workbook to another workbook using VBE.
Does anyone have any idea?
Thank u :D
What is it you are copying, an embedded chart, a chart sheet, a worksheet,
or a workbook? If it's a chart, are you copying just the chart, or the chart
and its data? Is your intent to use the data from the new workbook with the
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
"y0ngb00n" <firstname.lastname@example.org> wrote in message
&g...adding wookbooks together
I have 2 workbooks in the same foler and I would like to add them
together....the help menu said to put them in the same folder go to tools and
choose "compare wookbooks" but that line is not active. Any suggestions
If you have two workbooks open, you can drag worksheets from one to the
other, or right-click the sheet tab and choose "move." They don't need to be
in the same folder. How did you word your help query? I'd like to see this
one for myself.
> I have 2 workbooks in the same foler and I would like to add them
> to...Excel2000 keeps asking me to save when no changes were made
Excel2000 keeps asking me to save when no changes were made. This only
happens on a few workbooks and has only been hapening the past 4 months. As
time goes on it is happening more frequently. Ran Norton Anti-Virus, no
viruses detected. Ran Spyware software, no problems there either.
Have you got any of the following volatile functions in your workbook, as
the existence of any of these will cause that message, because that function
is recalculated every time you open the workbook, and as far as Excel is
concerned that is a change. Most common one I would suggest is the TODAY()
...Possible to detect changes to an XmlDocument object?
If I instantiate an XmlDocument object, the load a file through the Load
method, is there a way, later on in execution, to easily determine if the
XmlDocument object has changed from the original version loaded?
I'd like to be able to check a condition to see if the document in memory
has been editted (i.e., nodes added, attributes changed, etc.) so that my
user can decide whether or not to commit changes to the disk file before
moving to another file.
Will I have to resort to re-loading the file, and comparing OuterXml
Gabe Covert wrote:
> I'd like t...Use first day of month formula in a drop down list
I'm using the formula =DATE(YEAR(B4),MONTH(B4),1) where cell B4 = Today()
and this works to give me the 1st day of the current month.
My question is:
How do I use this in a drop down list on a separate worksheet in the same
workbook? I have tried to name the cell containing the 'date' formula, but it
looks like Excel does not allow naming a cell with a formula. Each time I
name the cell (select the cell, click on the 'name box', type name, enter)
when I re-select the cell it hasn't changed the cell name. It defaults back
to the row/column name.
Than...Is it possible to compare a string and a field name
I have the following tables: Membership, Subscriptions, OfficeUseOnly. The
Office Table contains a Year, Year To and From [financial year] and the other
fields are the 5 membership types (regular, student etc) and these 5 fields
contain the different amount each type of member has to pay.
I want to create a form whereby on entering the financial year and the
membership type the correct amount is automatically inserted into the
FinancialYear - in current form = OfficeUseOnly SubsFinYear
and then if MemberType = 'Student' find Student field ...Show all bills/deposits for the month
I recently updated from 2000 to the 2005 version. In 2000 you could see all
of your bills and deposits for 1, 3, 6, and 12 months. Is there a way to get
2005 to do that?
Forecast cash flow. M02 changed this. See
"jrfrantz" <email@example.com> wrote in message
> I recently updated from 2000 to the 2005 version. In 2000 you could see
> of your bills and deposits for 1, 3, 6, and 12 months. Is there a way to
> 2005 to do that?
This is my bigge...Report by Year, Qtr and by Day
How can i create a report by Year, Qtr, day using pivot?
Is it possible?
I have 200,000 data on my clipper program, and it has all the details by
date, can i use pivot to summarize report by year, qtr, day without
Thank you so much!
Drag the date field onto your pivot table as a row or column field, then
right-click it and select 'Group and Show Detail' from the drop-down menu.
Should be easy from there,
Go to http://www.edferrero.com/tutorials.aspx for more info.
> How can i create a report by Year, Qtr, day...pictures in various shapes
Is it possible to insert a picture and make it into a circle or an oval or
various other shapes than just squares and rectangles? Thank you ahead of
with a graphics editor
Microsoft MVP - FrontPage
"Stephanie" <Stephanie@discussions.microsoft.com> wrote in message
| Is it possible to insert a picture and make it into a circle or an oval or
| various other shapes than just squares and rectangles? Thank you ahead of
> Is it possible to insert a pict...Graphing a Line Using the Equation
Is there a way to graph a line using the equation of the line?
try this url
see chapter 15 and refer to "charting a function"
tortoise25 <firstname.lastname@example.org> wrote in message
> Is there a way to graph a line using the equation of the line?
See PLOT manager
and Stephen Bullen's ChtFrmla.zip at
http://www...OWA login issue for one user only
I have only one user who cannot access OWA on Exchange 2007. When he logs
in, he gets the following:
Url: https://%OWA SERVER%:443/owa/lang.owa
User host address: %IP ADDRESS%
Exception type: Microsoft.Exchange.Data.Storage.StoragePermanentException
Exception message: There was a problem accessing Active Directory.
owaContext, OwaIdentity logonIdentity, CultureInfo culture, String
timeZoneKeyN...Reference end of month balance on previous workshhet
I want to dedicate a separate worksheet for each month for a period of
several months showing daily adjustments to a beginning daily balance based
on a variable multiplication factor to produce an ending daily balance. My
problem is that the ending balance for the previous month could be in any
one of four cells (rows)depending on how many days in the previous month (28
to 31 days). For each new month, I would like to retrieve the ending
balance for the previous month by referring to the cell (row) that
corresponds to the last day of that month regardless of what actual row it
is in...Is this possible
I want to make a list of the files in several different
folders. Is it possible to somehow "Copy and paste" just
the filenames into a list, in either Word or Excel or
Wordperfect. I am just trying to sort the files in
several different folders to weed out duplicates. There
has got to be an easier way then typing them all or screen
printing the lists and manually weeding them out. Any
Here is some code that will start in a directory and list all files in that
and any sub directories. It uses recursion to go through all the subs.
Just ch...message routing based on subject line
Our firewall inserts [SPAM] at the beginning of each spam message
subject line. I would like to route those tagged messages to a public
folder. I have not found a way to control message routing based on
subject line. Any assistance would be appreciated.
"Milton" <email@example.com> wrote in message
> Our firewall inserts [SPAM] at the beginning of each spam message
> subject line. I would like to route those tagged messages to a
> folder. I have not found a way to control...Keeping track of employee training
Hi all! I am trying to set up an Excel spreadsheet that will list al
of the employees in our department, along with all of the training eac
employee has. I would like to set it up so that I can keep track o
when an employee's training certificate is about to expire (probabl
with colour codes: yellow when a training certificate is due to expir
in 3 months and red when a training certificate is due to expire in
Yes, I know there are lots of posts on this topic but I don't have an
formal excel training and I can't seem to find any templates to eve
set up what I am trying ...Is this Possible ?
Have a newsletter document with text boxes that have no outlines but
internal gradient colour fills.
Is it possible that a macro could remove all colour fills in one hit just
leaving the text in place ?
Dim oShape As Shape
For Each oShape In ActiveDocument.Shapes
If oShape.Type = msoTextBox Then
If oShape.Line.Visible = msoFalse Then
oShape.Fill.Visible = msoFalse
should clear the fill from text boxes that are filled and have no border.
<>>< ><<> ><&l...