I have a question of how to convert date into week no.in excel 2003?
Example: convert 26-03-2008 to week 13 2008?

I using trig functions (i.e. sine, cos and tan) and i wondering if there is
a way in excel settings so that i do not have to convert my input into
radians beforehand.  I am using quite complex formulaes and adding Radians ()
or pi()/180 would add another level to the formula ...

I'm having trouble adding up all the sub-totals in my timesheet.
I have a number of sub-totals in h:mm format for each week of the month. I
used the AutoSum function to calculate each of these weekly sub-totals.
When I try to calculate my total hours for the month (i.e. add up all ...

I am attempting to use a lookup formula to determine the next iteration in an
array.  
For instance, if the cell = 21,000 then I need the result to be the value in
the array immediately lower than 21,000, in this case 20,000.  In the next

I have something that is confusing me greatly.  Here's the condensed
version:
I have a formula in L5.  I want to test to see if the result is an
integer.

I have a client in Australia that uses dd/mm/yyyy as their default date
format.   Applications that use DATEVALUE or similar functions that take a
date string used to work on "24/03/2008" but now they do not.
Am I missing something, or is this an error/enhancement in Excel 2007?  ...

I am trying to count the number of times all names in a list are listed. I
have 1200 names and many are listed many times.  I need to find out the
number of times the names occur.  I am using Excel 2003 Any help?

I use a handheld scanner to read barcodes. How do I make excel automatically
tab to the next cell after input.

Private Sub CommandButton1_Click()
Worksheets("Schedule").Range("d1,a3:a100,b3:B100,d3:d100").ClearContents
Worksheets("Sent to Assembly").Range("a3:a100,b3:b100").ClearContents
End Sub

what is the formula in working with degree days where you want to say
subtract degree day that was above zero degrees but will add to a number when
the deegree day is below zero such as -10 degrees.
Thanks

hi how do i calculate cumulative return on the rate of return of
mutual funds

Gentlemen,
Can any one tell, how to calculate average loan period of a 5 year loan, say
a US$5 million loan, payable in  quarterly instalments at rate of 5% p.a..
The first in stalment starts at the end of 1st quarter.

Cell A1 contains a "critical value". I want to format the range B1:B5 so that
one cell is highlighted - the cell with the value closest to, but not greater
than, A1.
E.g. if B1:B5 looks like this:

I have a list of people from different states with names, addresses, etc over
several columns... They're all on the same sheet and the sheet is updated
frequently (people are added).
I then have a tab for each state and would like each tab to update according

What I am trying to do is take a percentage of a value in a column I
added in the data field divided by the automatic Subtotal the pivot
table creates as a new row for each column. I'd like to have this
formula be in a new column/calculated field.