Excel Adding years or months to a date
I want to be able to add months or years to a date.
For example 25/4/05 + 9 months
25/4/05 + 15 years.
I am using Excel 2000.
The standard way is:
to add 9 months. For 15 years try:
> I want to be able to add months or years to a date.
> For example 25/4/05 + 9 months
> 25/4/05 + 15 years.
> I am using Excel 2000.
On Mon, 25 Apr 2005 06:54:03 -0700, "Joan" <Joan@discussions.microsoft.com>
>I want to be able to a...Credit Card Returns
If a customer buys something with a Credit Card and returns it, does RMS
process the refund back to the clients credit card?
> If a customer buys something with a Credit Card and returns it, does RMS
> process the refund back to the clients credit card?
Even though the new 1.3 "deletes" credit card info after batch settlement?
If a customer purchases an item today, and return the item tomorrow there
would no longer be a card number in the database. For that scenario you
would have to have the card present, even if it is a 'recal...Excel working in with Outlook
I have Office 2007 so obviously Outlook 2007 and Excel 2007.
I have made up a newbie's Excel spreadsheet for my business. One thing to
open that has my entire financial year's data in it and my car logbook. One
thing I am going to add to it is parts. I want to know when parts need to be
re-ordered so will set a level where I want Excel to show up basically
something like a "reorder now" warning. However, I am often in a hurry,
record the event and don't look at the outcome until I have some time, late
at night. At that time, reordering becomes a nightmare.
Is ther...excel export available
I have a query that I wish to export the results to Excel. However, the
Excel button on the Export Data tab is grayed out? It used to work. Any
ideas of what makes the Excel Export unavailable?
...Creating an Excel table from Access
I have an Access database which I use to log downtime for systems. I have a
requirement to produce a monthly report based on this data, however, this
needs to be exported to excel in a specific format.
Down the left side of the report need to go the names of the services, with
the days (numerically like: 1, 2, 3 .. 29, 30 etc) across the top. Then I
need to count the number of times each service was down on a give day, and
insert that information into the necessary cell - so if intranet services
had been down twice on 16th March, for example, there would be a 2 in column
16, whi...Import contacts from Excel
I have numerous contact lists with various categories and wondered if i can
import them into an email distribution list so that i do not need to hand
type each email?
"angie" <firstname.lastname@example.org> wrote in message
>I have numerous contact lists with various categories and wondered if i can
> import them into an email distribution list so that i do not need to hand
> type each email?
You can't import into a DL. Instead import into your Contacts and assign
categories to ...How to lock a line put on a graph in excell
I am trying to attach a line to a graph with months on the X axis. When I
add additional months I want the line to stay in between the original months,
however, it always moves as the graph expands.
Drawing objects cannot be linked to specific values of chart axes, unless
you incorporate them as series in the chart. Try the techniques here:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"Dennis" <Dennis@discussions.microsoft.com> wrote in message
news:336...Sorting all folder contents in Outlook 2002??
My personal folders and sub-folders are presently not sorted by
received date, so it's a pain to constantly have to hit the "received"
tab when I open a folder to see the newer messages on top. Is there a
way to change the default setting and have ALL my folders sorted by
Is there anyway i can make the addresses i see show up when i am reading a
reset the view - right click on the field names and click on the customize
menu thenchoose reset.
if you need help finding the reset option, see
http://www.outlook-tips.net/beginner/viewm...Random Sampling in Microsoft Excell 2002
Hi, I'm trying to create a random sample using the Data
Analysis tool in Excell. The problem I'm having is that I
can't figure out how to make a non-repeating sample. I
want all the observations in the sample to be unique. How
do I do this without manually deleting the repeat entries
on the output worksheet?
next to the entries, put in the formula
then drag fill down the column.
Sort the data and this column with this column as the key.
Then take the top "n" items.
"EJ Ford" <email@example.com> wrote in mess...Not possible to remove mail reminders in outlook 2002
I have a big problem with old mail that keeps popping up as reminders.
I've tried to start outlook with /cleanreminders and another parameter
Is there anyway that I can delete these reminders for sure?
My mail originally comes from outlook in office 97, I know use outlook
2002. The mail that I get reminders on are mails from that period.
Very grateful for any help that you can give me.
- Kjell Arne
...Excel is not counting
In excel 2003, i entered a number in a column and dragged down the rows to
count the consecutive numbers automatically, but it was just copying the same
number instead counting. How to change so as to count?
Life isa journey not a destination
Do the same while holding the CTRL Pressed.
> merry x'mas
> In excel 2003, i entered a number in a column and dragged down the rows to
> count the consecutive numbers automatically, but it was just copying the same
> number instead counting. How to change so as to...Excel Formulae #2
I have a spreadsheet with value in one column & a series of dates in 5
other columns.For each row depending on the value
in the first colunm a date may be applicable in one or more of the
other columns.e.g 550 in the first column will mean dates will be
inserted in the next 2 columns similar to authority levels. My qn. is
how can I show what's outstanding if the relevant authority levels have
not signed off-basically this is used as a tracker of invoices & I
would like to show what is outstanding awaiting approval at anytime.
----------------------------------...Querying Excel data without another program
I'm an intermediate user of Excel, but I have lots of experience using
Access. If you can give me clues on how to handle the information below
using only Excel, I'd be grateful!
I have a spreadsheet in Excel 97 in which there's a Worksheet named,
"Datasource" with a column "B" containing repetitive data.
I'd like to create a new worksheet in the same Excel file which shows a
single instance of each item used in Column "B".
If I were writing the query in SQL, I'd say
"SELECT DISTINCT [Column B]
FROM [MySpreadsheet]![Datasource...Add a Word Document as a Tab in an Excel Document
I work on several documents that require both worksheets and written reports
- being able to add a word document as a new tab in Excel would be a neat way
of integrating the two into one file for storing/printing/emailing.
"Office Binder: Gone but Not Really"
PC Magazine article, January 29, 2002 by M. David Stone on using Binder in Office XP
San Francisco, USA
"GoDamN" <GoDamN@discussions.microsoft.com> wrote in message
> I work on s...running excel in background
I'd like to run a program that writes values from one
cell to another with a VBA program that is triggered by
the clock. I've completed this part but, since I use
active cells, you can't run another workbook without the
clock activating the cell in the active worksheet. It
needs to run in the background all day long. - ideas?
will it run in the background if I don't activate cells?
Try launching another instance of Excel.
mvpearl omitthisword at verizon period net
"Don" <firstname.lastname@example.org&g...how do why update my Excel microsoft office
how do why update my Excel microsoft office
If you have office 5, you probably would want to update
"sam" <email@example.com> wrote in message
> how do why update my Excel microsoft office
...How do I export email addresses from excel to outlook?
I am trying to do a mail merge using email via outlook. I have 200+ addresses
and I'd like to know how to import the addresses into the contacts section of
outlook to do the merge from there. I've tried the help part of out look but
it comes up saying that the excel file has no named ranges and that I should
use excel to name the range of data to be imported.
Any help much appreciated.
In outlook select file/import export/ import from another program or file/
and then follow the instructions from the wizard.
Why do you want to do the mailmerge from Outlook? You can...Outlook 2002 connector: problem connecting with Domino server because of NAMELookup2 problem
I'm trying to use Outlook 2002 Connector to connect with a Domino R5
server, but I can get no connection.
From the log file I see that the connector uses a NAMELookup2 with the
correct Domino server to get the name of the mail file, but the name
its gets back is corrupted. There are spurious characters at the end
of the mail file name.
From the MSOCLog.txt file
<<67c 25 16:37>> User name : : CN=Jean-Paul Smeets/O=Someorg
<<4f8 25 16:37>> NAMELookup2 called with m_pServerName=someserver
Flags=0 pNameSpaces=0x13646F4 NumNameSpaces=1 pNames=0x12E6CC
NumNames=1 ...No Smart Tag help: just a blank "MS Excel Help" window
When I invoke "help on this error" on a Smart Tag drop-down, a blank "MS
Excel Help" window appears with no content. The general help pane that
appears via <F1> etc. is fine - it's just the Smart Tag help option that
doesn't show anything, just a blank window.
Win XP Home SP2
Excel 2003 (11.6355.6360) SP1
...Email Help: Sending Outlook email from Excel VBA
How do I select a specific property in outlook while sending email from excel?
There is an option we can set in outlook outgoing emails call "Voting buttons"
in that feature there is a custom option that we can select called "Have
replies sent to" its a checkbox. I want it checked when i send an email from
Hope i made it clear.
Thanks in advance
If sending through the Outlook Object Model, use the MailItem.VotingOptions
property and MailItem.ReplyRecipients collection.
Dmitry Streblechenko (MVP)
OutlookSp...Excel 2003 - VBA
What is a simple way to check to see if a sheet of a given name is present
in a workbook?
Dim Sht as object
set sht = nothing
on error resume next
set sht = activeworkbook.sheets("somesheetnamehere")
on error goto 0
if sht is nothing then
Craig Brandt wrote:
> What is a simple way to check to see if a sheet of a given name is present
> in a workbook?
Thanks for the quick response.
Works like a champ,
&q...Excel data disappeared after getting message about compatibility M
I tried to save changes to a spreadsheet, and received the following message:
"Compatibility Report for New Customer List.xls
Run on 4/6/2010 19:52
The following features in this workbook are not supported by earlier
versions of Excel. These features may be lost or degraded when you save this
workbook in an earlier file format.
Minor loss of fidelity
Some cells or styles in this workbook contain formatting that is not
supported by the selected file format. These formats will be converted to the
closest format available."
I clicked OK, because fidelity is not imp...Autonumber stopped incrementing to next highest number
I have been having this strange occurence on one of my relationship table -
not frequently but 2 times is enough for me.
Apparently the Autonumber seems to stop incrementing to the next available
highest number and begin to give a number
that's already in existence . That of course will give the error on "Unique
identifier - blah blah blah"
To temporary correct this problem I have been copying the table to a
temptable ( structure & data ) -
rename the corrupted table and then rename the temptable to the original
name of the corrupted table.
This works, but I'm lo...Using Emit to Return a Value
I am trying to write a piece of code that can implement an interface's
methods simply by returning a specified value. I am trying to see how
Mock libraries are written.
For instance, I have a piece of code that looks like this:
What I want to be able to do is somehow implement ISomething.Foo so
that it returns "abc". However, I am having a hard time figuring out
the Emit code for taking an arbitrary object and incorporating it.
I've never want...How-To: Last change date on row
When I set up a database I always include a last change date that auto
updates every time any field in the record changes. Does anyone have a
suggestion for how to achieve a similar function in a spreadsheet. i.e.
put the current date/time in a field in the row whenever anything in the
GGG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29220
View this thread: http://www.excelforum.com/showthread.php?threadid=489447
For example, to put the last change date in...