date and text concatenation
I tried to concatenate cell A1 with date (27.07.2005) and cell B1 wit
text (INVOICE 777) by using formula in cell C1 (=A1&" "&B1)and receive
the following result *38560 INVOICE 777*. But I want to see the resul
as *27.07.2005 INVOICE 777*. How to avoid the date convertion? Pleas
littleps's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2548
View this thread: http://www.excelforum.com/showthread.php?threadid=39053
Basically, I would like to create a function where example
if I type 02/04/2004, the column next to it will automaticall
increment of 2 months, become 02/06/2004.
So, my function is below:
=DAY(A1) & "/" & (MONTH(A1) + 2) & "/" & YEAR(A1)
But, this function got problem, which is the leading zero, meanin
02/04/2004 will become 2/6/2004
How do I fix this? Thanks
Message posted from http://www.ExcelForum.com
but use format|cells|number tab to give it the format you like.
"ngaisteve1 <" w...Money 2004 Small Business: Invoice Date vs. Due Date / recurring invoice
I'm trying to set up a recurring invoice to be sent out on a monthly basis.
The only way I figure to do this is by entering it into bills and deposits
but that wont create an invoice for me automatically. Is there a way?
Also, when I create a new invoice, it asks for the date that is pre-filled
with todays date. That would be fine if that were the Invoice Date but when
viewing the invoice preview, the Due Date is taken from that field also.
Therefore, Invoice Date is the same as Due Date. That ain't gonna cut it.
I need to bill 2 weeks in advance. Any thoughts?
...Increase size of pie chart within control?
Is there a way to increase the size of a pie chart within its control?
I have a limited amount of space in which to display the chart, so the
overall size of the control is restricted. But within it there's quite a lot
of "wasted" white space and I would like to make the pie itself larger and
more legible. Can do, or not?
In design mode, double-click on the chart within the control to select it
for editing. Then use the sizing handles to resize the chart area to the
size of the control; this does not have to be square. Click on the plot
area to select it ...I need a formula to sum column b if column a is between two dates
I have an excel spreadsheet with employees time off. I need a formula that
will add column b if column a is betwee two dates. For example: if column a
is between 9/22/04 and 9/21/05 then add column b. I have tried all different
formluas but can't get this to work.
...DST 2007 patch for CRM 1.2
Would anyone know if DST 2007 patch is required for CRM 1.2. Greatly
We will know when the DST patch is officially released.
Microsoft CRM MVP
"Marcos" <Marcos@discussions.microsoft.com> wrote in message
> Hello All,
> Would anyone know if DST 2007 patch is required for CRM 1.2. Greatly
I have seen nothing for this on the DST Site and I have 2 clients using v1.2
asking what they s...How do I copy a date from excel to a outlook calender?
I am looking to produce a spreadsheet with various amounts of data on. One of
the bits of data will be appointment dates. Can Excel, (or any other
database) update outlook appointments with either little on no user
intervention? If so, how?
...Drivers for percentage increase
I am trying to set up a driver to include in my budget profile so that my
managers can select the percentage from a driver and see on each budget line
what the outcome will be i.e
staff costs may be calculated at 150,000 but if I used my driver to
calculate an increase of 3.5% that would change the staff costs to 155,250.
Can anyone help?
I am not sure what you question is but this may help:-
In cell A 2 I have 150,000
In cell B 2 I have 3.5%
In cell C 2 I have:-
- and this returns 155,250 to cell C 2.
If my comments have helped please h...Year end close with 1 database and 5 entities
I have one data base with 5 entities. Each entity has its own Retained
Earnings account. MGP only allows one Retained Earnings account to be used
when closing the year. I currently now must do a journal entry to reclass
each entities Current Year activity out of that one Retained Earnings account
and to its own Retained Earnings account. I have been using 12/31/yy as the
date of the reclass entry. It however creates an out of balance for each
entity's Balance Sheet. The out of balance amount is the Current Year's
1. Does anyone else have this issue? If you...MS CRM 1.2 and Exchange 5.5?
Does anyone know if it's possible to install the Exchange
router on Exchange 5.5?
Its not possible - you must have Exchange 2000 or 2003
"Bryan" <email@example.com> wrote in message
> Does anyone know if it's possible to install the Exchange
> router on Exchange 5.5?
I have a table of employee information, which include 2 fields called Start
Date and End Date.
I want to be able to run a query that enables the user to enter a date range
to find those who are between a specific Start Date and End Date.
Example: Find those between Sept 1, 2008 (Start Date) and September 30, 2008
You need to be a bit clearer on what you want. I am guessing that you want to
match records where the period Start Date to End Date overlaps fully or
partially the days in the date range that is input.
WHERE FldStartDate <=...to increase quantity
hello everybody, i have a question: i want to use project to calculate
the delivery time of a machine component. I know the bill of material
and the time of every step (manufacturing, mounting, etc.). I don't have
problem to create a gantt for this item: but i have problem when i want
to create a gantt for a number greater than one of my item. I think that
i have to use a function that increase the duration of each step of the
process, but i don't know how. Please help me.
Im trying to do somthing that I am guessing is quite simple.
Im working on a Db that tracks a fleet of rental skiis. Every 2 years these
skis must be tested.
I have a table that tracks all the information about a given pair of skis,
including the date they were last tested. What I am trying to do is have a
feild within that table autocomplete using the [test date] feild, plus 2
years. This new feild would then become the date when the next test was
The Table is called [Ski Info]
The first date feild is [Test date]
the feild I would like to have calculated is [Next te...Date Wont Display As Date
This is a simple one, I hope.
Here is the problem formula:
I am trying to get this formula to show as:
Instead I get:
Any ideas on how to get the date to show and not the date code?
Pick one of your liking.
"Minitman" <firstname.lastname@example.org> wrote in message
> This is a simple one, I hope.
> Here is the problem formula:
>...future dates in payables
An end user accidentally entered payables transactions in future dates such
as 2229. We do not want to have to create fiscal periods for years so far in
the future. But, if we have to, we will.
Anyway, how would we void or get rid of transactions accidentally entered
with future periods?
Why can't you just delete the transaction? You can't post to a period
that hasn't been setup.
East Coast Dynamics
The client says that there are some transactions in the system like that that
she cannot...Printing 1/2 page postcards
I am trying to print two similarly designed postcards on one page but with
different addresses. I am using MS Publisher 2003. Is there any way to do
Select custom in page setup, type 5.5 in the height box, Publisher will print
two per sheet. This is the setup you will use for mail merge and two cards per
If each card is an individual piece, you will have to setup a custom size in
your printer. You can use a mail merge or print one card at a time, manually
changing the data each time.
Mary Sauer MSFT MVP
...1) lost basis in time for merged stock 2) Bond reocurring payments not available
Has anyone a solution to these important investor
problems with MS Money 2002. I downloaded the trial
version M2004 and it is the same.
Reports show incorret annual rate of return for basis in
a merged company:
If you record a merger of a stock using the "Record a
special activity" feature in an investement account, the
dollar amount of your original investment in the acquired
company is transferred to the acquiring company, as it
should be. When you run an investment performance
report, the annual rate of return for your basis is
lost. The report displays the result as ...X axis date
I'm using Excel '97 (Yeah, I know, but it's all I can afford at the moment)
I want the X axis to always display a month beyond the latest date, so
that the line graph stops short of the right hand side.
I can get the Y Axis of value to stay ahead of the game by a consistent
amount, but the date defaults back to the latest date when Auto for Max
value is ticked.
Is this possible? Will I have to use VBA?
Please clue me in.
Add a series to the chart. It can consist of a single point, where the date
is calculated as the maximum in your date column plus 30, an...Date Increase
I currently have a form for entering current passwords for systems. I have a
field to enter the date the password was last changed, and another field for
the date the password expires, which is every 30 days.
Is there anyway i can set the date password expires field to update
The 2nd field is just calculated from the 1st and better left as a
calculation in a query rather than a field in a table. There are no triggers
at the table level in Access.
Dan Wood wrote:
>I currently have a form for entering current passwords for systems. I have a
>field to enter...Differnce between two dates
I want to dermine how mnay days there is between cell c6 and g6 if g6
contains a value, if not then i want thee code to do nothjing.
You didn't mention which is the Start Date and which one is end date (i.e.)
whether the start date is C6 Or G6.
If the Start Date is C6 and the End Date is G6 then use the below formula
If the Start Date is G6 and the End Date is C6 then use the below formula
Remember to Click Yes, if this post h...can I increase excel column numbers to more than 256?
I am trying to analyse tables including more than 256 variables. I cannot
transpose them into rows because the program i am using in association with
excel (xlstat) takes the columns as the variables. Is there a way to increase
the number of the columns?? or is it a fixed specification of the excel
worksheet? thank for any help!
Yes, it is fixed - you cannot increase the number of columns. You can,
of course, split your data up into chunks of 250 columns - the first
block of data on row 1, for example, then the next set starting on
another row etc.
...Graph displaying dates alphabetically on x axis, not by date
Title says it all - I want the x axis to show dates in DATE ORDER, not
I've read thru the forum, can't see how to fix it - your help will be
p.s. Here is the graph Row Source, should there be an ORDER BY statement in
SELECT (Format([Date Paid],"mmm"" '""yy")) AS Expr1, Sum([Tenant Payments].
Amount) AS SumOfAmount FROM [Tenant Payments] GROUP BY (Format([Date Paid],
"mmm"" '""yy")), [Tenant Payments].[Date Paid], (Year([Date Paid]...Dates
I am working on a spreadsheet that consists of a rolling 12 mont
period. Once a month has passed how do I delete it and add a new mont
to the 12 month period? Please help
~~ Message posted from http://www.ExcelForum.com
You have to provide more info on how your data is laid out. Tell us what
you have and tell us what you want to have when the month changes. HTH
"erodri02" <email@example.com> wrote in message
> I am working on a spreadsheet that consists of a rolling 12 month
> period. Once...Date filled down?
I would like to put a date in a cell.
Then fill it down. How to do that?
Tuesday, July 06, 2004
Wednesday, July 07, 2004
type the date as dd/mm/yy or mm/dd/yy or whatever is default for your
then choose format / cells
click on custom, type in the box on the right had side
dddd, mmmm dd, yyyy
now click on fill handle (bottom right of cell) and fill down as far as you
want - adjust column width if needed.
"Ming He" <firstname.lastname@example.org> wrote in message
news:e$4TSb9YEHA.3304@TK2MSFTNGP09....$997 PROFIT Per Order 1 to 2 Deals Per Day! #2
$50,000 a month
That's What Our Top Associates Earned Last Month Without Ever Talking
To A Prospect.