To tie adjusted book balance to the GL at a point in time require that a
cutoff date be used for reconciliations? Is there any way to reprint the
reconciliation report for a particular check book or only by audit code?
...getting error out of date range
i am getting an error out of date range when make an appt
on a calander ( sending to someone else the are gettign
the error )
...Counting how many different names in a long list
I have a list of 332 names many of them are duplicated. I am looking for
a formula or function that can count how many unique names there are in
Can anyone help?
Quaisne's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28052
View this thread: http://www.excelforum.com/showthread.php?threadid=501357
This'll count the number of distinct values in a range:
(adjust the range to matc...Sumifs with data and dates
I need a formula for each item in col A that was added during 2010 only. the spreadsheet will have years of data.
Expense Date Amount
Furniture 1/12/2010 $326.00
Inventory 1/15/2010 $250.00
Utilities 1/15/2010 $98.00
Rent 1/29/2010 $1,000.00
Rent 1/30/2010 $536.00
how can I Sumif with Critera in Col A and only for a specific year?
Submitted via EggHeadCafe - Software Developer Portal of Choice
Silverlight, WPF, XAML and InnerWorkings Coding Challenge
http://www.eggheadcafe.com/tutorials/aspnet/f...date in cell comment
I want to put todays date with a certain format (d-m-yy) in the comment of
cell B3. Can't find the proper code. Please help.
Public Sub InsertDateInB3()
On Error Resume Next
On Error GoTo 0
.AddComment Text:=Format(Date, "d-m-yy")
In article <eFOqwq6jFHA.firstname.lastname@example.org>,
"Jack Sons" <email@example.com> wrote:
> Hi all,
> I want to put todays date wi...Showing date last saved
I want one of the cells on my worksheet to show the date the file was last
saved on - and to update automatically.
What's the best way to do this?
You need code to do this,
One way to do it, copy this code into the this 'ThisWorkbook' window in the
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Sheet1.Range("A1").Value = Date
Sheet1.Range("A2").Value = Time
This will put the date saved into A1 and the time saved into A2. To have the
date and time in one cell use
Sheet1.Range("A...Counting rows of blanks across certain columns
I have a survey whose answers were recorded in Excel. The answers for a
particular question extend from Q6 to Z505. I need to count the people who
did not answer the question (that is, the people, entered in rows 6 to 505
that left columns Q through Z blank). I'm not sure how to do this. Can
someone offer a suggestion?
You can use a formula like this in Column AA
copy down till AA505
You can use a simple Sum formula now to count the empty ones
Regards Ron de Bruin
"crossingboston" <...Monthly year to date average
I have scores for given records for a particular date:
I would like to be able to average these scores by month, but have a running
March 61.5 (average 56 & 67)
April 55.3 (average 56, 67, and 43)
I think I need to use a DAvg function, but it isn't working yet.
*IF* you have only ONE record per month, you can try:
SELECT a.date, LAST(a.qty), AVG(b.qty)
FROM tableName As a INNER JOIN tableName As b
ON a.date >= b.date
GROUP BY a.date
that would give:
1/15/2007 56 56
3/15/2007 67 61.5
I have a rather large list of dates that are in a column and are written
first as year then month then day Ex: 20051116. I want to change all of them
in a date format like this 11/16/2005 with out retyping each one. I have
tried to change the format but excel will not read it. I have tried to make a
macro but excel only changed that one cell not the entire column. Please
On Fri, 22 Apr 2005 17:29:30 -0700, "Quandary"
>I have a rather large list of dates that are in a column and are written
>first as year then mont...calculating dates prior to a given date
Hi. I am trying create a spreadsheet that will have dates listed in one
column and have another column list the date 14 days prior to the first
column's dates. I'm hoping to then organize the second column ascending from
the closest to the furthest date, compared to the current date. If anyone
has any help they could provide it would be much appreciated. Thank You.
If you have a date in A1 and you want another date in B1 which is 14
days earlier, then put this in B1:
Copy this formula down, then fix the values by selecting all those
cells with the formula ...Calculating date difference
I need to calculate the number of years of service for
person(difference between Start_Date & End_Date). The result should b
in terms of years, months and days (all in one single cell). Ca
someone please help?
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
Have a look at Chip's site:
"rll" <firstname.lastname@example.org> wrote in message
&...how do you keep a column in date form
i'm making a spreedsheet in office excel, in column A I have a list of dates.
I would type in 4/5 for an date and excel would automatic change the date to
4-Apr. I like this way, but when I got to cell 26, the change will not
happen. I type in 4/5 and I get just the number 1 in the cell, for the rest
of the cells down, can someone help me.
Copy the cell that has the format you like and paste format it to the cells
that you want to have the date format.
"s2m2" <email@example.com> wrote in message
news:F350F90F-24B9-4B79-BE39-20AB0414015D@microsoft.com......Field with running count of records
I have a query with fields such as date, Item Number and Quantity. I want
to create an additional field called Count that will act like an autonumber.
It will assign a value of 1 for the first record, 2 for the second number
etc. Can someone tell me how to do this?
There are tons of posts on how to create a "ranking" query. You must have a
field or fields that uniquely identify the sort order. If you provided
significant table and field names as well as your desired sort order, someone
could create the SQL for you if you can't search for and fi...Adding text and date problem
I have text in column 1, a date in column 2 and in column 3 I wish to
show the text followed by the date.
I have tried both Concatenate and & but the the result is text followed
by the underlying number representing the date. I cannot seem to format
this column to show the date as dd/mm/yy. Any suggestions?
="Today is: "&TEXT(A1,"mm/dd/yyyy")
Microsoft MVP - Excel
"newman" <firstname.lastname@example.org> wrote in message news:464C1646.AC6A42E0@despammed.com...
|I have text in column 1, a date in column 2 and in column...date in register from epay
When sending an epay on a specified date it does not post
in my register on that specified date. It shows a date 6
days prior to the requested date. How can this date be
shown on the specified date?
I expect epay does this for a reason. Nonetheless, you can always overtype
the date with whatever you wish.
"John Vanek" <email@example.com> wrote in message
> When sending an epay on a specified date it does not post
> in my register on that specified date. It shows a date 6
> days prior to the requested date. How can...Autoformat dates and times
I have a workbook with two columns. In the formula bar of one of the cells
i have 2005040101700 (YearMonthDateHoursMinutes), but what shows in the cell
When I try to format the cell as yyyymmddhhmm I get ########### and when I
put the cursor over the cell with ############### it says that negative dates
and times are shown this way. How can I make this work?
I'm hoping that your actual value is different: 2005040101700 doesn't make sense:
year 2005 month 04 day 01 hour 01 minutes 70 seconds 0
Perhaps it's really
200504010...post date benefit changes
In either GP 9.0 or 10.0, is it possible to post-date changes to employee
benefit codes in payroll for changes in amounts?
There is the Start Date field in Employee Benefit Maintenance. But, this
cannot be used for post-dating changes as the next payroll run that you
conduct (if before the start date) will not use the benefit code.
Is there a third-party that will do this?
GP Payroll does not support post-dated deductions/benefits. The Advanced HR
module provides the ability to do effective dating on HR benefits and, by
extension, Payroll deductions and benefi...writing meeting notes with DAte stamps
I am new to Outlook coming from ACT and trying to understand best way to take
notes, attach to contacts and make sure the date is automatically input in
notes. I would loveto use one program to manage my contacts, but Act has
been very easy to use.
what version of outlook?
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
I am trying to sum the amount of time two words "high" and "very high" appear
in a col....I can get this to work for one word but when i try and nest the
statement it doest work - Why and how to i solve it.
=COUNTIF('(R2) Risks Log'!L9:L99,"Very High",CountIF(Risks
First, your question is ambiguous. Are you tring to count the number of
times a cell's contents - as a whole - is either "High" or "Very High"? Or
are you looking to count how many times the a) word or b) phra...Date Modified changed Money 2005
I am not sure what is going on. After I closed the Microsoft money file for
the night about 2 hours later I noticed that the time change of when the
files was last updated. Example.
I ran the Program and money file at 8 pm. I was done by 8:30 pm. but I
noticed it chaged the date of last modified to 10 pm.
Sould I be worried that someone might be hacking in to my system? how can I
tell who last accessed the file and where from? is Microsoft sending updates
to my passport acount with out me knowing it?
please help me out.
Should I be worried?
Have you a Pocket PC...Account list view up to current date?
I'm using MS Money Plus Deluxe. I often enter in income/expenses far
in advance so I can see how things will play out. Account list is my
main view and gets distorted since it is taking into account future
events. The portfolio view has a nice feature in that it can show
only up to the current date and not any future events, such as future
retirement contributions I've entered. Is there a way to make the
account list do that? Or, is there some way I can see both scenarios
without having to maintain two Money files?
Bills | Forecast Cash Flow?
Beyond that, no. You could not enter...Displaying Total Word Count on Cover Sheet
Operating System: Mac OS X 10.5 (Leopard)
I want to display/show the Total Word count of my document on the Cover Page, when I print my document is is there on the Cover Page. How can I do that? Is there an Auto Text or something like that that I can use? Please anyone reply please.
You can use Insert> Field to insert the NumWords Field from the Document
Information category. However, the field does not update automatically. You
need to update it manually by clicking in the field & pressing F9, by
Control/Right-Clicking the Field & selecting...Showing how much longer for a due date.
I am trying to figure out how to show how much longer someone will have to
send a product back if they only have 30 days to return it. I would like the
cell to count down from 30-1 and show colors at different stages. Is this
possible or am I asking too much?
You need to be more specific on this. Is there any date element associated
with this or you are going to enter the date on which someone returns the
product back on the scale of 1 to 30 days.
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
New Delhi, India
"daddyr" ...report date range
I have a report that will display data from an inventory transaction history
form. There I would enter in the date and several other criteria. After doing
so I filter the form to my selection and then print my report. I wanted the
date range that is on the form to print on the report. I hvae done this in
several other reports and never had a problem until now. I'm getting #NAME.
The form is still open upon viewing the report. On the report I have a text
box with the logic of:
="Report Date Between: " & [Forms]![frmInvTransactionHistory]![BegtDate] & "
and &...Calculate Due Date?
I need a formula that will calculate a due date 10 days from the start
date (a1)but if the date falls on a weekend or holiday I need the date
to be the next working day.
I will have a list of holidays in J2:J50.
Thanks for any help..........
"Randy" <firstname.lastname@example.org> wrote in message
> I need a formula that will calculate a due date 10 days from the start
> date (a1)but if the date falls on a weekend or holiday I need the date
> to be the next working day.
> I will have a...