How can I enter a date without having to type a "/" between the month, day,
magstate, have a look here
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
"magstate" <firstname.lastname@example.org> wrote in message
> How can I enter a date without having to type a "/" between the...Previous Balance Incorrect
I spend a god deal of time last weekend updating and balancing accounts (ok,
so I was lazy for a few months). So my statement for January came in for my
main checking account and to my surprise, it says the last time I balanced
was July. When I decided to do it all again, it brought up the wrong
starting balance. Thinking I could correct by putting the correct balances
in, it let me re-balance the July statement, but the starting balance once
more is incorrect for the next statement. I'm afraid to go any further. None
of the other accounts is experiencing this issue. Has anyone ever...Windows Live Mail "Received Date" issue
I have recently decided to move my Google Apps business email account to
The only way I have found to 'migrate' my emails to my Office Live email
account is by dragging and dropping the emails from "GMail" to my Office
Live account using the WLM GUI.
WLM (GUI and Web) will display an incorrect received date - which is the
migration date of when I have subscribed to Google Apps email. The only way
I have found to show a correct date is to display the "sent" column in WLM
Is there a way to correct this ? Maybe there is a ...Simple question: Difference between two dates?
Suppose cell A2 has 6/27/05 - 7/1/05
A3 has 7/4/05 - 7/8/05... and so
I need to know the formula to coomputer the number of days betwee
those dates, which is obviously 5. The reason it need to keep the rang
in one cell is this will be used in a VLookup function. Thanks
dstock's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2422
View this thread: http://www.excelforum.com/showthread.php?threadid=38132
Anyway you slice it, you have to get the 2 dates seperated...
So you can have ...Document in Times New Roman
Operating System: Mac OS X 10.6 (Snow Leopard)
Document sent to me in Times New Roman does no open up with text, only squiggly horizontal lines
Ensure you have updated both Mac OS X and Microsoft Office. OS X should
show you an update level of 10.6.2, Office 12.2.3.
On 5/03/10 12:52 PM, in article 59bb3f30.-1@webcrossing.JaKIaxP2ac0,
"email@example.com" <firstname.lastname@example.org> wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Document sent to
> me in Times New Roman does no open up with text, only squig...My Work 2.0 Framework Calendar Error
In "My Work" and I go to Calendar we're continuing to get an unexpected
error. This is only on one of our clients. Out of four installs this is only
happening at one of them. This install is also the most NON-customized
solution as it's basically a straight out of the box install right now.
"Unexpected Error". An error has occured. For more information, contact your
We are getting an ASP.NET 2.0.50727.0 error in the event log (see below).
Does anyone know how to correct this?
Event code: 3005
Event message: An unhandled exception has o...Sum products prices that are between two dates
I was wondering if someone could tell me what the formula would be if I
wanted to add the prices of products that were purchased between two dates.
If column A was formatted with the dates between 01/01/06 and 31/01/06
and column B with the prices.
Thanks in advance
In cell D1, enter the Start date required in cell E1 enter the end date
In F1 =SUMPRODUCT(--($A$1:$A$100>=D1),--($A$1:$A$100<=E1),$B$1:$B$100)
Change the ranges to suit.
"Maddoktor" <email@example.com> wrote in message
news:e1v...Incorrect Version starts when I double-click document
Is there any way to stop Office 2004 from starting when I doubleclick
a document when using OS 9? There are some programs that I need to
use while booted in OS 9 (not classic) and this is becoming a problem
when I need to open Office documents as well.
Thanks for any advice you can give me.
On 11/5/04 9:35 AM, in article
firstname.lastname@example.org, "Janet Moe"
> Is there any way to stop Office 2004 from starting when I doubleclick
> a document when using OS 9? There are some programs that I need to
> use while booted i...Outlook 2007
I sync my Contacts & Calendar with my pda phones. From time to time, I mess
my Contacts & Calendar and would like to back up a copy of Contacts &
Calendar separately. Can someone advise how to accompany it.
If you check out MS outloook site there is a free backup addin
"Scott" <NoSpam-Scott.Xe@GMail.com> wrote in message
>I sync my Contacts & Calendar with my pda phones. From time to time, I
>mess my Contacts & Calendar and would like to back up a copy of Contacts &
>Calen...I cannot change the date format to English canada
if you'd like to change the format of one cell, select the cell and
After selecting the cell, go tot he format menu, choose the first
From the pop-up form, goto the Number tab (should be the first one)-
in the category section- choose date, in the locale section choose
then choose the format in the Type section. choose OK.
It should work.
If this is not what you ment, please let me know. Also, indicate what
you've tried and why it hasn't worked-
---------------------------------------------------------...Flagging up dates in cells #2
All sorted now
midase's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15863
View this thread: http://www.excelforum.com/showthread.php?threadid=273554
...How do I sort by date (not days, weeks, months) in Excel 2000?
not sure what you're asking here, if you could type out say five lines of
your data and then what you want to see, i'm sure we'll be able to help
(please, however, do not attach a workbook)
"Tony" <Tony@discussions.microsoft.com> wrote in message
...averaging a value between two serial dates
I have two spreadsheets. The first spreadsheet contains two columns, one for
start date/time (in serial format) and the second for stop date/time (in
The second spreadsheet contains two columns. One containing a serial
date/time and the other containing a meteorological value (eg. temperature).
I want Excel to read the start and stop date/time from the first spreadhseet
and then search the second spreadsheet for all temperature values which were
recorded during this time frame.
Lastly, I want Excel to average these values.
Is this possible using a single Excel func...Yet, another TIME problem
Okay, I will attempt to explain my situation without just confusin
anyone who reads this.
I have a time sheet. It consists of the following fields:
Time Started/Lunch Begin/Lunch End/Time Ended/Total Time/Over Time
In the first four fields the cells are number format (looks lik
military time but in reality it isn't) ie: 0630/1130/1230/1600
In the fifth field, the total time is a decimal value. It always read
8.00 or less and carries the remainder,if any, to the over time fiel
which is also decimal value. The overtime has to be reported in quarte
hour increments ie: .15, .25, .50, .75....mdf file date wrong
I hvae a client that has the log and the data file in the same place for
years. Same drive, same folder, etc. )I know it's a good idea to put the log
elsewhere but it's not necessary here). Anyway, my question is regarding the
date of the mdf file. THis is in SQL 2000 running on Windows Server 2003.
Everything is up to date. We're moving things over to SQL 2005 so I was
going to do some testing last night when I noticed the date on the log file
was 1/10/2010 but the date on the data file is 11/15/2009 11:57 AM. Their
office has been up and running this morning for a f...Date Formula Needed-Business Days
I need a formula that calculates business days, but the NETWORKDAYS function
is not adequate. I need the formula to return the number of days between two
dates, excluding a range of holidays. Since my store is open seven days a
week, the NETWORKDAYS function will not suffice. When I used Quattro Pro in
the past, it had a BDAY function, and it accepted parameters to indicate if
weedends were to be included or not. Is there a comparable function in Excel?
I am trying to calculate the number of days the store is open every week. I
thought of using NETWORKDAYS and simply adding 2 (Satu...Enable/Disable User update time on Exchange 2003
When I enable or disable a user in AD, it take a long time for those updates
to take effect in Exchange.
How can I set/change the time that it takes to update this info?
...Cannot share calendars
We are using Small Business Server 2003 with Exchange. When we open up
Outlook 2003 the "Share My Calendar" link is not visible in the
Navigation pane, even though we are using the Exchange server that came
with SBS 2003.
Any suggestions would be much appreciated.
...calculating time formula
i want to set up a time summation calculation in excel.
for example i put in how many hours i've working on something over a number
of days down one column and a "Total hours and mins worked" cell somewhere
else just adds all my inputs in hour and min format. eg. 03:20 (ie. 3 hours
- thanks for any comments.
just enter your time values in Ex^cel's time format and use a formula
Important: Format your target cell with the custom format [hh]:mm
"Nick" <email@example.com> schrieb im ...Formula and field types for calculating times
I don't get it how to format fields and apply some formula to calculate
I want the difference of two time fields expressed as
12:30 - 08:15 = 4.25 (4 hours and 15 minutes)
and format as General
Gary''s Student - gsnu2007d
To learn all about calculating with time, visit Chip Pearson's site:
Microsoft MVP - Excel
"Hans-Martin Burger" <MartHof@gmx.de> wrote in message ne...cannot open recurring appointments
I dont know if this is an outlook issue or an exchange issue. We are running
outlook 2003 w/ exchange 2003. I have a user that when ever he tries to open
a recurring appointment he gets , Item cannot be found.
Can someone help.
Have you tried "outlook.exe /cleanfreebusy" in the run dialog box?
> I dont know if this is an outlook issue or an exchange issue. We are running
> outlook 2003 w/ exchange 2003. I have a user that when ever he tries to open
> a recurring appointment he gets , Item cannot be found.
> Can someone help.
>...Change cell colour by date
I'm working on a spreadsheet for a maintenance program. I'm looking for a
way to change the cell colour depending on when a task is due. For example:
when a monthly task is due I would like the cell colour to change to remind
me that it is due in a week.
Use Conditional formatting, see details in Help!
„Dri” ezt írta:
> Hi All
> I'm working on a spreadsheet for a maintenance program. I'm looking for a
> way to change the cell colour depending on when a task is due. For example:
> when a monthly task is due I would like ...CRM <-> Exchange Server Calendar
Is there any way in CRM 3.0 to link the User calendar to the matching
Exchange calendar other that via the outlook client which I cant get to work
ovr RPC HTTPS
thanks in advance
...Contract posted with wrong dates
We have had a few issues where a contract is posted and invoice generated.
The invoice is generated but not posted. Our contract department would like
to be able to cancel the contract or change the start/end dates due to a
change in our relationship with the customer. Is there any way to do this or
is our only option removing the contract through SQL and creating a new one?
...Transpose week numbers to date
One of my users would like to have certain cells in his spreadsheet, where
if you type a week number it will transpose it to a date.
For example 01 might be 01/04/2005, 02 might be 08/04/2005 and 52 might be
I am clueless on this one, and not very good at Excel anyhow
Thanks in advacne
Assume the week number is input into cell A1:
B1: =DATE(2005,4,1) + 7 * (A1-1)
Format the cell as a date.
Note that I get 24/03/2006 rather than 25/03/2006 for A1=52.
In article <27203F81-566E-4539-A116-56FA9F1219F6@microsoft.com>,