It'll change the date format of how things are displayed in places like
Windows Explorer, but I assumed that you wanted to set things up the same
way they had been on your previous machine?
--
David Biddulph

"Cassidy1" wrote in message
...
I'm not a real computer whiz so I have to ask this - won't this change
the
date format of everything on my computer?

"David Biddulph" wrote:

Check your Wiindows Regional Settings (in Control Panel).
--
David Biddulph

"Cassidy1" wrote in message
...
Hi Max, since you helped me with this calculation, I have gotten a new
computer and had all my programs and documents etc copied over to it.
For
some reason, in excel, all my date formats were changed from dd/mm/yyyy
to
mm/dd/yyyy and my date calculations are not working now. I have gone
in
to
"format cells" and set the format to custom which changed my date
fields
back
to dd/mm/yyyy, but my calculations still don't work.

"Max" wrote:

Assuming referral dates in col J (dates are assumed real dates),
areas in col K (V, S etc),
you could try something like this:
=SUMPRODUCT((TEXT(J2:J147,"mmmyy")="Mar08")*(K2:K1 47="V"))
to return the referrals in Mar08 for area V
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cassidy1" wrote:
Hi,
I have an excel spreadsheet that contains info on referrals; date
received,
area received, client file number etc.
I need to figure out how to track monthly referrals by area.
I already have a column that calculates total referrals each month
that
looks like this: =COUNTIF(J2:J147,"31/03/2008") and this works
great,
but I
have another column that shows the area referred: V for Victoria or
S
for
Sidney and I want to know how many referrals I received each month
for
each
area, so any help on how I would formulate that?

Thanks