Can anyone help with the weekday formula.
What I want to do is enter the date in say A1 11/20/2003 and have B
return the answer of Thursday. Currently I use the weekday formula bu
only returns the number of the day.
Thanks in advance
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
There are several ways to do this. One is to enter =A1 and format the cell
with a custom number format of dddd. Another way is to use the function
Hello, everybody !!!
Why this fragment of code shows : ac
Thanks All !!!
"Alex Dmitriev" <email@example.com> wrote in message
> Hello, everybody !!!
> Why this fragment of code shows : ac
'??/' is a '\' so you end up with "a\\\bc"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vccelng4/html/elc...Count formula within a named range.
How do I change the following formula
to count within a named range (PW Shopfitters).
Any help would be great.
A range name cannot have spaces, maybe that's your problem. Name your range
PW_Shopfitters. Then replace your cell references with PW_Shopfitters, eg
firstname.lastname@example.org_2nd_at. Randburg, Gauteng, South Africa
&g...Formula to return a formula
At least I think that's what I'm looking for. here's my situation:
I've got a sheet where there is a variable (X) that changes depending on
what row it is on. So I have a column (column c) that lists these variables
(X is dependant on things from a different sheet).
X is a muliplier that is utilized differently depending on the value of N. N
is a Picklist selection and can change periodically. Or even be duplicated on
more than one row.
I have a vlookup that checks the value of N (column a) and needs to return a
formula that has X applied if needed on the approp...How do I set up formula to copy format from one worksheet to anoth
How do I set up a formula to copy both value and format from one worksheet to
When I use the = sign, it copy the value only. How do I get the format be
you can't "link" the formatting in the same way as you link the contents
what you need to do is to copy all the cells in your sheet
X A B C ...
click on the grey square which I have illustrated with the X
this selects all the cells in the sheet
press control-C (copy)
go to your new sheet and select the same X square
now do edit > paste special > format / column width.
if you are doin...Excel Object showing strange behavior
I have a sheet that I created that contains an Excel object (small
spreadsheet) that when double clicked, will open up and allow it to be
populated. After they populate it, and close it,...the data is
automatically reflected in the object on the original sheet.
This is shared with everyone and it's working great. BUT.....(always
Why have a few people sent the form back to me saying that when they
double click the object it opens up a "Format Object" dialogue box
rather than the editable sheet that it was supposed to do? They sent it
back to me and sure enough...Dates in Formula
I want to create an IF statement that says if a cell value is equal to a set
date then "True" otherwise "False"
The formula used is:
=IF(A12="01/04/2004", "TRUE", "FALSE")
The value in A12 is 01/04/2004 (created by formatting cell to dd/mm/yyyy)
This returns "False" regardless of what I put in A12
I am using Excel 2000 on an XP Pro O/S.
Any help greatly appreciated.
On Fri, 14 Jan 2005 03:09:03 -0800, John G <JohnG@discussions.microsoft.com>
>I want to create an IF statement that says if a cell value is equ...Exchange Permissions--Strange One
by default, domain admins (and ent. admins) are denied "receive as" and "send as" permissions to the mailbox store. additionally, by default, on the exchange advanced tab under the mailbox rights button, domain admins are DENIED Full Mailbox Access. However, if you look at the security tab for each user object, by default domain admins are allowed "send as" and "receive as" permissions. now i know that the "receive as" right is ignored on the ad user object, but i ran a small test. i logged on as a domain admin, opened up the domain admin...Help for formulas in spreadsheet
Let me first explain my problem. I have a booking form used by renters who
rent my holiday villa, they book usually 1 or 2 weeks.
The cost is dependent on the month so there are 4 price bands. So they could
cross a price band ie have a different price for each week.
I have used this forum in the past to get a couple of formulas to do most of
the calculations, but as i don`t really understand the formulas when changes
are required its a no go area for me other than the yearly price increase, I
just change the figure (�s) behind the �s sign. All my changes are linked
to dates and ...Strange Email failure error
Can anyone help? Using Outlook 2002 and POP3 mail. I've always been able to
send emails to my wife's work email address until this week, when I get this
very strange failure notice.
"Connected to 126.96.36.199 but greeting failed.
Remote host said: 421 reppsrv01.repp.co.uk is not accepting new connections.
Please try later I'm not going to try again; this message has been in the
queue too long."
Does anyone know what the hell this means?
Google is your Friend
Email address deliberately false to avoid spam:
www.gbpcomputin...Formula for same numbers in Excel
I have 2 columns in Excel (C10:C200 and D10:D150) filled by numbers. How can
I find how many numbers in column D (and if it is possible which) included
also in the column C.
I would like to apply a formula and not any shorting method.
fill down to E200.
HTH. Best wishes Harald
"nikos" <email@example.com> wrote in message
> I have 2 columns in Excel (C10:C200 and D10:D150) filled by numbers. How
> I find how many numb...Write a formula for a penalty for status of TRUE?
Need to write a formula in column H for a penalty of $50 for the customer
that has a fixed penalty status of TRUE and $) for all others
Do you mean something like
"Esperanza" <Esperanza@discussions.microsoft.com> wrote in message
> Need to write a formula in column H for a penalty of $50 for the customer
> that has a fixed penalty status of TRUE and $) for all others
Assuming "$)" means "$0", try:
Adjust the ...Very Strange
I have a Word 2007 document. In this I am using 3 different heading styles.
I want to use the feature 'Select Text with Similar Formatting' but it is
not working. I have 5 headings that are all Title Case, size 10, Times New
Roman, Left aligned and Bold there is exactly the same formatting applied to
all 5 headings - I even checked the paragraph spacing - all headings are 0pt
before and 12pt after. I checked show and hide - everything I repeat
everything is the same - can you tell me why oh why will this feature only
select 3 of my headings and not the 5????
...Fantasy Football Datbase or Formula
i'm trying to create a Fantasy Football Datbase or Formula in excel ca anyone
...help with formula please
I want to change how this works, I messed around a little but no joy.
In cells C6,D6,E6 I have words date, month, year, In cells G6,H6,I6 I
have words date, month, year,
In cells C7,D7,E7 Date is entered dd/mm/yy, In cells G7,H7,I7
Date is entered dd/mm/yy
The idea is a start date and a finish date, It is based on renting a
property and will be either one week or two weeks
If the dates equal one week only then I wish cell M7 to print �150
If the dates equal 2 weeks then cell M8 to equal �100
Thus giving a combined total of �250 for two weeks rental. (which is later
added tog...Displaying Formulas #2
I have a workbook with 3 worksheets. On all three
worksheets, when any formula is entered, the result is the
formula. For example, in cell A1 I enter "=B1", the result
should be the contents of B1. But what is displayed
is "=B1". If I add a 4th sheet and enter the above
formula, it works correctly. It is just something in the
spreadsheet info that is preventing the formula from
the cell is porbably formated as text. Goto 'Format - cell' and change
the format to 'General'. Reenter your formula and it should work
J...Formula for Capital Letters
I am working on a Validation List
In cell D13, I want user to key in only letters A, B, C, D, or E and all
should be in CAPITAL LETTERS.
I use the formula below in
I got the Capital Letter part, but other letters can still be keyed in other
Please advise me, thank you.
In article <firstname.lastname@example.org>,
"Zainuddin Zakaria" <email@example.com> wrote:
> I am working on a Validation List
> In cell D13, I want user to key in only letters A, B, C, D, or E and ...why this strange result with vlookup
hi i have this formula in a cell =VLOOKUP(A3,'LookUp Data'!A2:O740,2,FALSE)
but any time i pick a code from my list items in column A it gives #NA but
as soon as i change to a different code it gives the name.
any help why
My best guess would be a data type mismatch. Looking up text in a column of
numbers. When you change the value the type gets converted and the result is
Hard to say though based on yoru description. The ohter thig to look for
might be blank characters padded at the end of the input.
"Amin" wrot...How to "clone" or "duplicate" cells & their formulas...
Copy-Paste-Special lets you do some useful things in Excel.
But there's no quick & easy way to "clone" a cell and make an exact
duplicate of it. Often I do this either because a given cell is a
good starting point for a different calculation.
The workarounds work, but, like workarounds, they kinda stink. For
example, you can edit the formula, put a quote in front of it & turn
it into a string, then copy it to wherever you need it, and then
finally edit it (and the original) back to formula. Or, you can use
absolute references in the formula and then copy the formula....DestroyWindow ASSERT problem....strange, strange!
I have derived a dialog-class in a DLL (shared MFC)
I can construct an object of this class in my app, and when overloading
DoModal() and adding an AFX_MANAGE_STATE(AfxGetStaticModuleState( ));
call, I can see the CMyDialog dialog.
But here is the issue, I have a timer set for a certain time, it posts
a message and the dialog has to be killed - so I use CDialog::OnCancel.
Then DoModal calls DestroyWindow() -
Here a copy of the m_hWnd is made in hWndOrig.
hWndOrig = m_hWnd;
Then m_hWnd gets set to Null by ::DestroyWndow (which calls
But later in Dest...Why won't Toolbars and the formula bar show up or stay in my workbooks?
Operating System: Mac OS X 10.6 (Snow Leopard)
Every time I open a spreadsheet there are no menu bars. Under View>Toolbars, both Standard and Formatting are checkmarked, as are View>Formula Bar, View>Status bar. If I uncheck and then recheck these choices, they appear for that workbook only. Next time I close/open workbook, they are gone again. What is this newby to MAC doing wrong? <br><br>Warm regards, <br><br>Rob
Click the little capsular button at the right end of a document's Title Bar
to turn off Apple's inn...Strange behavior #3
I use Outlook 2003 with a internal pop/smtp server (Merak). Using Oulook
2003 (it's the case for all users in the company), when we send mails to
internal addresses, in the recipient mailbox our address doesn't appear, we
are considered as ghost users! But, if on the same PC we use another email
client (Outlook express for example), the mail arrives with my address as
Does anyone feel a ghostbuster?
Thanks by advance.
I'm running Office 2007, and always back up my files to a flash drive
which I can then open in my laptop. The "Icons" always look normal until
today When I backed up an Excel file. The new Icon on the flash drive
has a big exclamation mark (!) in the center of it!! I have reviewed
the file and can't find anything wrong with it -- have been doing this
for years and have never seen this before. Will someone please tell me
what this means!! The icon in my "documents and settings", where the
file was saved originally is normal.
This is a cross post wi...Help with basic If Then Else formula
I am an experience computer user but probably only barely past basic
when it comes to doing formulas and such in programs like excel. I am
trying to create an IF THEN ELSE (I think) formula for a fantasy
football worksheet. Here is the situation. There will be four
winners, 1st, 2nd, 3rd, and 4th place. And there will also be an added
reward for completing the season with the most points. I have it look
something like this.
Playoff Finish Playoff Teams Most Points
Winner P1 x (c1)
2nd P4 (...Formula Transpose
In Excel2000, I have the following data in row 1 ( Cities )and formulas
(starting in row 2 that reference the cities) in :
A B C
1 NY LA SF
Is there an easy way make a formula in A2 that I can copy down.I have
many rows of this type of data.
Select A1:C1 and copy
Edit>Pastespecial and click Transpose
"snax500" <firstname.lastname@example.org> wrote in message
> In Excel2000, I have the...