Easiest way to get 3rd col = monthly averages, from cols 1, 2 = weekly date, data?
I've got years of data of the following sort:
(and so on, up to the present)
I would like a 3rd column, with an entry on each row representing the
last week of a month, whose value is the average of the data points
for that month. Note that the number of weeks in a month varies.
Greatly appreciating any quick & easy approaches,
Rather than trying to do it on all the rows that are the last week of a
given month, in column D starting at D2 enter
Format>Cells>Number>Cust...Populating the last Sun. date of that week in a cell
Thanks in advance.
I'm using Word 2003 & I'd like to populate a cell of a table to fill in the
last Sunday-DATE of that week. This is for a timesheet.doc where that date
needs to be filled in for our Payroll Dept. Currently folks are having to go
to a calendar & look up in order to manually populate this field. Many
Thanks Graham, I recognize this as VBA, but don't know where/how to do this.
I think if you give me simple instructions I can navigate through it enough.
Also just to clarify, what I'm after is (w/ today being the 27th) I'...Change Tracking Help?
I have a table with a varchar column and datetimeoffset column.
SQL Server 2008 (not R2) Change Tracking is enabled on the database
and the table and column-tracking is enabled.
On one DB connection, I inserted 3 rows.
On a different connection, I updated 1 row's varchar and
I want to know which row was updated so I can take some action. The
below SQL shows all 3 rows as "updated', I expected I guess 3 inserts
and 1 update.
CT.ItemsId, P.Stamp, P.ItemName,
...whole number fractions to proper fractions
MS Word 2004
As a cookbook editor, I receive countless submissions with the most
common fractions entered as whole numbers. I have quick correct to
convert these if I am typing them myself however I need a way to have
Word make the conversion on a per document basis rather than on a
manual fraction by fraction basis or even using Find/Replace as I do
now. In the old WordPerfect days, running spell check would do this as
well as convert generic quotes to typographer's quotes; Word does
Google has not been my friend in this search. Appropriate suggestions
from this for...Changing Budget Dates
I like to track my budget on Microsoft Money 2003. I have
set it up to give me budget figures based on the "current
month". I want to change the current month setting to
start on the 15th (payday) instead of the 1st.
Any clue as to how to do this?
Yes. Redesign/rewrite the application. Money doesn't allow you to do this as
it presently exists.
"Elizabeth" <email@example.com> wrote in message
> I like to track my budget on Microsoft Money 2003. I have
> set it up to give me budget figures ...Excel 2003 help
hi all gurus, below is the code to attach the excel file in an email, it is
only attaching one sheet within the document.
How do i get it to attach the entire workbook?
Dim sh As Worksheet
Dim wb As Workbook
Dim FileExtStr As String
Dim FileFormatNum As Long
Dim TempFilePath As String
Dim TempFileName As String
Dim Response As String
Dim DefaultFolder As String, DefaultFileName As String
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Response = MsgBox("Are you sure you want to submit this to ...Formula help... #3
In column A there are cells with team names in them like the following:
I would like column B to list all the team names without the @ symbol and
column H to list all the teams with the @ symbol. For the example I would
like column B to have
(remove nothere from the email address if mailing direct)
"Jambruins" <Jambruins@discussions.microsoft.com> wrote in message
news:135965C4-7523-47AB-88DE-D0B12B652CD5@m...viewing attachments inline....HELP!!
I've got a real quandary here. I've just upgraded to Office
2000, and when in Outlook, I can't view any attachments
inline (they usually come in as attachments). In Outlook
Express, they were attached as well as inline. Now Outlook
doesn't do that, and there is no tab anywhere in the
Options, etc as to be able to check that attachments my be
viewed inline. On my MAC (running Office v.x), Entourage
DOES have that option.
Is this lack of inline viewing "the nature of the beast"
for 2000?? I haven't had any luck searching the KBs...
Any input would be greatly appre...email date stamp
Can you tell me whether there is anyway to change the Outlook email stamp to
a different format
All emails from everyone all seem to have the following format
Sent: Wednesday, August 23, 2006 6:10 PM for recording when the email was
All emails I send use the same format.
A colleague of mine has told me that he can make Outlook stamp all his
outgoing emails with the following format:
Sent: 2006-08-21 05:28
Can individuals control this? if so how?
In your display?
View-> Arrange By-> Current View-> Customize Current View-> Format
Robert Sparn...Fraction Formatting
I am creating an employee time sheet, where the hours worked will be entered
in increments as small as 15 minutes and be displayed as fractions. For
example, I would like 2.5 hours to display as "2 1/2" and 4.25 hours to
display as "4 1/4". When I choose "Fractions" in the cell formatting and
select the fraction denominator as '4', 2.5 hours displays as 2 2/4, not 2
How do I set the formatting to display as I want?
just format it as "Up to two digits (21/25)"
"David Rose" <drose@com...outlook prints date footers
While printing MS Outlook mails using visual basic code, it prints with date
footers for HTML mails (only for html). We cleared the headers and footers
of outlook and IE print page setup. But also it shows the same problem. So
please suggest a solution for this.
Thanks & Regards,
...Mem_Bad_Handle Please Help!
I have a Mem_bad_handle issue. I realise I dont have a reports.dic and
forms.dic. The reason I dont have it is because I dont have the opportunity
to run modifier and report writer yet. I can't run the mentioned apps
because when I use Utilities for the first time I always get the above
error. Please help.
Are you running GP remotely?
"xs" <firstname.lastname@example.org> wrote in message
> I have a Mem_bad_handle issue. I realise I dont have a reports.dic and
> forms.dic. The reason I dont have i...date extraction
I have a macro set up that pulls out the dates from my information.
I am not sure but I think what I have below is the spot that defines the
date format to pull out my dates from my data. If I put 2/2/10 it does not
pull out the date. If I put 02 it does pull out the date. Is there a way so
it will pull it out whether I put 2 or 02 for the month?
Selection.NumberFormat = "m/d/yy;@"
Get it as a String and then convert to a Date:
Dim s As String, d As Date
s = Selection.Text
d = DateValue(s)
Gary'&...Subtracting dates to get hours... but I want to skip weekends
In column A I have start times (DD/MM/YY HH/MM/SS) and in column B I
have the stop times. I am measuring the hours from the difference of
these columns for each row, in column C.
However, I would like to exclude weekends from the subtraction. I.e
Friday 5 pm is the start time, Monday 8 am is the stop time, then the
difference would be 15 hours instead of 63 hours.
I know how to convert the fractions returned from the difference, into
hours/minutes/days, and I also know how to convert dates to "day of
week", so unless you guys know of a good idea I was just going to sort
the file...re:error in installing kb955706 from vista up date
any solution about the error so that it can be install successfully
> any solution about the error so that it can be install successfully
Please always state which Windows edition and Service Pack level ? and what
version of Internet Explorer? as it often does make a difference -
Also, could you supply some information on what your firewall is, what is
the installed antivirus/security suite, other R-TP programs, e.g. Spybot
Search & Destroy (reduced functionality called "TeaTimer") Avira (From
version 9) (Included in anti...Default Value =Date$() in UK Date Format
I have a form with a date field and want to populate it with the current date
using the =Date$() in the default value field. Unfortunately this uses the US
date format (mmddyy) and I need it to be in the UK format (ddmmyy). Regional
settings are set to UK on the PC.
Can anyone please advise me how to acheive this as I can't find any
reference to it anywhere on the web!
Should use your regional setting
"Shugwan" <Shugwan@discussions.microsoft.com> wrote in message
>I have a for...Error in Replying All to email in History in CRM 3.0
My client was trying to create a 'Reply All' to an email in history, the
email having many recipients in it. So my client just clicked Reply to All
and typed her message and sent it, but had this error:
A record with these values already exists. A duplicate record cannot be
created. Select one or more unique values and try again.
FYI, when forwarding there is no error.
Email is working perfectly fine for other CRM tasks. They can attach files
and everything. Only in this instance they are having error.
...Updating from M2001 to M2005...need help!
I currently have M2001 and want to update to M2005. If I do this will is
automatically update/transfer my info into 2005. If not how can it be done?
Also, has there been many problems doing this?
It should do, so long as the versions are from the same country, eg UK->UK
or US->US. There can be problems, but the easiest way to find out is to get
the trial version for the version you require.
Glyn Simpson, Microsoft MVP - Money
Check http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny or
http://money.mvps.org/faq for UK tips and fixes for MS Money. ...Importing dates from text file
I have counter data from a windows 2000 servers which I am trying t
graph. The text file has data in the format below.
"(PDH-CSV 4.0) (GMT Dayligh
Disk Queue Length","\\SERVER1\Processor(_Total)\% Processor Time"
"04/01/2004 00:00:11.115",&quo...Help on CListCtrl
Iam using the Report view of CListCtrl. I have to sort the
rows based on the values of a column which the user
clicks. When the user clicks on the column header the
first time, it should rearrange the rows in ascending
order of the column values. When the user clicks on the
column header the second time, it should rearrange the
rows in descending order.
Now, the following piece of code works perfectly to
rearrange the rows in ascending order when I click the
column header for the first time. But it doesnt rearrange
them in descending order when I click on the column header
th...Using NOW() in SQL for date fields
I am just a newbie when it comes to SQL, but I am very amazed with its
In a default mdb database I use "NOW" to filter a query with a datefield.
Like: SELECT * FROM tblOrders Where (((tblOrders.OrderDate) Between now()
But in SQL this does not seems to work, how can I use the now statement in
�.............. CHARLIE ..............�
If you want to filter the records by date without the time then it's better
to use Date() that return the date, when Now return ...Recommended Currency Expiration Dates
In our testing of Multi-Currency, we were unable to post some A/R
transactions as we got an error message of: "Error: The Exchange rate has
We are currently importing Currency Rate data on a daily basis from the
Federal Reserve website. As such, should we make the expiration date say
10-30 days from the Currency Date?
I presume that if we do that, the rate which will be used will be the
closest to the Invoice date. Is there any downside to having an Expiration
date overlap the life of another currency? (i.e. if We have a Currency Rate
for 10/31 expiring on 11...Investor's Knowledge Analysis
Investor's Knowledge Analysis
Please fill out the survey on Investment awareness & knowledge
Check out this neat website I came across. You can find it here:
Thanks for reading!
...Need Help With Files
I'm not sure if this is the right forum, but here goes:
I have an excel file that runs several macros (lets call it File1).
need to create another file that will have "text" information tha
depends on the day of the month (lets call it File2).
I'd like to create macro or VB script that will copy data from File
and put it in File1.
Even better and heres my ultimate dream: when the data in file2 goes t
file1 it is in 'Comment' form...
Can anyone help
Message posted from http://www.ExcelForum.com
Here's my code:
...How do I convert dd/mm/yy date format to yyddd Julian date format
I have done this before, but can't remember how!
"itzy bitzy" <email@example.com> wrote in message
>I have done this before, but can't remember how!
Format cells > Custom > and in "Type" enter: yyyy dd mm or whatever you'd like
"itzy bitzy" wrote:
> I have done this before, but can't remember how!
with custom format, choose the range to...