formulae for dates
gives an output is mm/dd/yy on entering 0 years x months
but if I enter 0 years 10 months or 11 months it gives me wrong date e.g if
entered 0 years 10 months it gives 31 april 2006
You are missing the space between the quotes in your formula
"Gerald" <Gerald@discussions.microsoft.com> wrote in message
When I noticed the clock on my pc was wrong, I changed
the time zone from Pacific to Eastern which is my correct
U.S. time zone. After doing this, all of the items
inserted as "all day" appointments in my monthly calendar
are displayed with an image of a clock on either side of
the appointment. The option to display clocks is turned
off in the settings. Why is this happening and how can I
prevent it from happening. Right now, I've had to put
back the Pacific time zone and adjust to the pc not
telling the right time. Is there any other solution?
No ...Today's date as a vertical line on Bar chart
There is probably a way to do this but I do not know how.
In XL 2007, on a dynamic stacked bar chart set up as a dynamic gantt
chart, is there a way to make today's date appear as a dynamic vertical
I copied my settings from my older desktop computer but I can't send or
receive e-mail on this laptop with Windows 7. Any suggestions?
Assuming you installed Windows Live Mail...
Do you get any error messages? If so, right-click on it, select Copy. then
Paste it into a reply here.
Windows 7 Ultimate 64
"Pam" wrote in message
I copied my settings from my older desktop computer but I can't send or
receive e-mail on this laptop with Wind...Send/Receive continues 1000s of times
When Outlook does its regular send/receive it ends up sending and receiving
thousands of times. The task pane shows an ever increasing number of tasks
that it says have been completed successfully. When all it actually is doing
is rechecking the mail accounts I have, over and over again. Literally
thousands of times. This interferes with anything that I want to do in
Outlook while this is going on.
It seems to have started after I downloaded either the latest version of
itunes or the latest version of Adobe (or some other application like that).
Help! And thanks.
Per Roady - MVP, th...One time code
In either an SDI or MDI application, if I want to include some functionality
( such as serial port configuration and control thread) that can only be run
once per application instance, where should that code go? I looked at the
App class but it doesn't handle user messages ( at least by default ).
Should the main code and worker thread go in the MainFrm class in the
www.Newsgroup-Binaries.com - *Completion*Retention*Speed*
Access your favorite newsgroups from home or on the road
If it has to do with the "wi...Have to set up exchange account details in outlook for new users manually
I'm quite new to AD + Exchange so please forgive any stupid questions.
When I create a new user in AD I am able to create a mailbox in
exchange for the user at the same time. However, I then have to log on
as the user, and am prompted to configure the email account details in
Outlook. Is there a way (and I'm sure there is) the Outlook details
can be completed automatically please?
Am using Windows Server + Exchange 2003. Clients connect via Citrix.
On 10 Mar 2007 10:04:51 -0800, "Coopa" <firstname.lastname@example.org> wrote:
Can you tell me about good tool for vs-6 that can tell me what functions in
my application take the most cpu time?
In article <u$YZa3o9EHA.2680@TK2MSFTNGP09.phx.gbl>, email@example.com
> Can you tell me about good tool for vs-6 that can tell me what functions in
> my application take the most cpu time?
VS 6 includes a perfectly good profiler, which does exactly this. If
you're working inside the environment, go to the link tab in the
project settings, and click the "enable profiling" check box, then do
a 'rebuild all' to gene...Month Function on UK dates formats (dd/mm/yyy)
Hi, (Excel 2007)
I'm in the US, created 2 tabs, 1 with US dates (formatted as DATE) and the
other tab with UK dates (also formatted as DATE).
File sent to UK to enter dates (dd/mm/yyyy)
=MONTH works find pulling out months from US dates, but fails on some UK
FAILS on =month(13/1/2010) #VALUE! but ok with =month(12/1/2010). I suspect
it is failing because it's "out of date range".
My goal is to pull out the month from all UK dates.
THANK for your help!
It may be for than just a formatting issue. For example in A1 enter:
1/13/2010 (US format...Date, Weekdays
Could you please help me with date formula.
I need to enter 2 days before but it must be a weekday.
e.g 12 Sep 2005 must show 9 Sep 2005 and also 13 Sep 2005 must show 9
What I have is NOW()-2 , but it shows 10 Sep 2005 which is wrong.
Heckstein's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27153
View this thread: http://www.excelforum.com/showthread.php?threadid=466653
> Could you please help me wi...Date + 10 days?
I have a field that shows the date I sent a notice to someone. I want to
create a field that automatically shows the date the notice is due back,
which is 10 days from the sent date. I would also like the field to show up
in red when the due date is past.
> I have a field that shows the date I sent a notice to someone.
> I want to create a field that automatically shows the date
> the notice is due back, which is 10 days from the sent date.
>...Time Out a MsgBox
I have a file that runs a macro when it is open. This file may be opened
manually or automatically by a macro from another file.
If the file is opened manually I would like a MsgBox to prompt the user to
end the macro before it gets into the body of the code.
If the file is opened automatically I would like the MsgBox to automatically
respond after a time delay to allow the macro to continue running the bulk of
Is there anyway to force a response to a MsgBox after a preset amount of
time with no response from the user?
How about this instead which closes...Setting Outlook Today as a default view in registry
I need to know what registry key I need to update and how
to setup Outllok Today a a default view in Outlook 2003.
...How do I set default comment font
Setting Excel text in Options | General tab doesn't effect comment text size.
I want to set comment text to larger size by default
--To change the default font size (this will also change the settings
for tooltips in Excel and other programs):
Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK
(Note: selecting a font type here will not affect the
default font used in Excel's comments)
Paul Matrix wrote:
> Setting Excel text in Options | Ge...Calculating time and pay in excel
Hi, i'm trying to make a spreadsheet that can calculate pay per minute
depending on an average length of time worked. Its driving me crazy and
any help would be greatly appreciated! Coloumn A is length of time, at
the bottom is a total time, next to that is an average length of time
worked and this is then multiplied by the amount appropriate for that
average. What would be the best way to work all of this out
Many thanks for any help you can give
wobbleman's Profile: http://www.e...Am I behind the times?
I have just installed Exchange sp2 on my SBS 2008 boxes and all went well.
One weird thing at the end of one of the installs it said Web Apps (I think)
couldn't restore default configuration, but everything seems to be working
So then I went to look for updates and I see a few that I must have missed.
I use WSUS on the network. One is Exchange SP2 update rollup 3. Go for it or
no? Second, Windows Server 2008 SP2. Yikes, when did that come out for SBS?
I wonder why it never popped up before since it looks like it's been out for
quite some time. Nonetheless, s...How do I use same date parameters for different queries and report
I'm having the same problem as Gavelle described below.
That is: I've followed the advice and set up a form to have my queries and
reports pick the dates from the form. But the queries/reports are still
asking me to
enter the beginning and ending date parameters for each query/report.
Also, when i set up the form it runs the query correctly. But when i try to
run the query (or report based off the query) I only get a general parameter
box stating Enter Parameter Value "forms!FORMNAME!StartDate and another for
the end date. Everything in my query criteria is typed correc...run time error
When I attempt to import a text file (.txt) in to Access, an error occurs. Run-time error �3163�: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data When I click the Debug button this pops up: .Fields("TranType").Value = rs("MoveType").Value A different error occurs when save it to my desktop, and this is what happens.Run-time error �2185�: You can�t reference a property or method for a control unless the control has the focus. When I click the Debug button this pops up: MsgBox "Import File Not Found:&quo...Start Time & End Time
I have a table of data for my Scheduled cutting list that is exported
from another program into an Excel Spreadsheet and from this table I
would like to be able to find the start and end time of the production
runs automatically in a separate table.
The table is set up like this
Planned order Time Product Description Volume
12345 08:00:00 Product 1
23435 11:32:00 Product 2 5680
14567 13:24:00 Product 3 10000
and so on.
I can find the start time by us...Date Lookup
Hi, assuming the following data:
1 31-Dec-2009 50
2 4-Jan-2010 30
3 5-Jan-2010 20
In C, I have the date for the first day of every month e.g. 1-Jan-2010. In
the adjacent cell in D, i need to lookup the value in B for the first number
that occur for that month (in this case 4-Jan and so, the number should be
30). I tried various formula but as there are no 1-Jan in column A, it
returns the value of 50 (31-Dec). Anyone here has a solution for this? Thanks
If there was a 1 jan in your data what would you want to return th...displaying the date of every 7th day in a colomn
I would like tio display the date for every Monday in a colomn starting from
a past Monday date. Can anyone be of assistance?
George, with your start data in A1, put this in A2 and drag down as far as
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"George the machinist" <George the firstname.lastname@example.org>
wrote in message news:73B42142-116A-474D-8627-DCA4EF98EB7C@microsoft.com...
> I wo...Transferring freight more than one time on a sales order
We frequently have partial shipments of sales orders and we leave the sales
order open until everything has shipped instead of creating backorders. The
system will allow you to have several tracking numbers for each order but you
can only transfer the freight once. I would like to make the suggestion to
be able to transfer freight more than one time.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, ...Incorrect Time Stamps
Exchange seems to be stamping the wrong time on emails and events
sporadically. All the times on servers are correct. Any thoughts?
Craig Tuttle - Level I Exchange Tech
The time stamp can also be handled by the client. Which exact time field is
being stamped wrong? Have you verified that the client has the correct time
(i.e. Daylight savings time set correctly)?
"Craig Tuttle" <CraigTuttle@discussions.microsoft.com> wrote in message
> Exchange seems to b...subtracting 28 days from a date
I know this is simple, but I am at a loss...A1 is a given date...A2 needs to
be 28 days prior. Formula please?
On Wed, 6 Jan 2010 14:40:03 -0800, Billrpc
>I know this is simple, but I am at a loss...A1 is a given date...A2 needs to
>be 28 days prior. Formula please?
Try this formula in cell A2:
Hope this helps / Lars-�ke
Got it, I knew it was simple, but I still don't know what was wrong.
> I know this is simple, but I am at a loss...A1 is...How chart time scale x-axis with another date serie
Hello all. I have this problem, I will need to create this chart that I don't
know how to.
Serie 1 is below which needs to be time scaled
Serie 2 - needs to plot the three dates in serie 1's time scaled X-Axis with
I will look something like you have a line of count on a time-scaled chart,
with 3 dates point in the x-axis. Please ...