I have a excel sheet with one column is date field.
My data is in the format of mm/dd/yyyy and my regional settings are dd/mm/yyyy
can any one advice me how to convert the data in to above said format.

I receieve payments every two weeks.
I have a budget spreadsheet and I want to set up a function which tells me
the number of even-numbered weeks in the current month. I can then multiply
this figure, by the amount of each payment and include it in my budget

Jeff wrote:
I would like to be able to create a dynamic range to pull the last seven days
of data from spreadsheet and place it in a different table in the same
spreadsheet.

I have excel 2003 and I want to be able to create a column with y's and n's
and count up the number of y's and n's
I also want to be able to do this with the letters b w a h o in order to
calculate the number of people from different races.

I have a spreadsheet that has addresses down column A and Types of
inspections across Row 1.  The rest of the table is filled with the dates
that the inspections have passed.  I need to be able to generate a list of
the inspections that passed for a given month.  That list should ...

I am wanting help on getting a formula to lookup column A and B. A has
numbers and B has dates.
I want a formula that will tell me when the amounts in Column A turn
negative for the first time.

Sheet1 A1 shows:  =Sheet2!D40
What I’m trying to do is:   Offset (Sheet2!D40,-15,0)
I want to do this on Sheet 1 off of cell A1:  Offset (Cell referenced in
cell A1,-15, 0).

Sorry I am still on my L's
I want to compare the prices of two columns from two suppliers to see which
is the cheapest to enable us to buy better, and so that our staff can quickly
order the cheapest prices without tooooo much thought.

I have a cell with numbers.  I need them to be 4 digits long, so they're
formatted as custom, using 0000 as the custom format (the numbers have
leading 0's).
Now I'm trying to combine this cell with another cell, but it won't keep the

I am using Excel 2003 to calculate standard curves from
spectrophotometry data. The intercept of the linear regression
equation has to be set to zero. Generating trendlines from an x-y plot
of the data, this is no problem; I can just set the intercept in the

Is it possible to implement conditional formatting based on text contained
in a cell?  Example, user wants to be able to highlight all the cells in a
spreadsheet for a given entity (which will change all the time) so I'm
looking for something like "cell contains xyz" -- but as ...

Need to display every nth row of data from an existing worksheet into a new
worksheet.  Any suggestions?  Thanks

I have text with embedded non-printable characters through out a large
worksheet of data.
For example,
Collected $98 incash, $5checks4/25/02 Moved, left no addres

I have a stock sheet in which i keep track of the date that stock was
received, where the stock is stored and the total stock. I enter the date
that the stock was received and the date that it was entered into the storage
place. What i need is for the Total Stock sheet to ...

How can i use If statement using two row, multi colums to get sum dollar
amount. For example
            colums A   colums B   colums C   colums D   colums E
ROW 2       100.00      100.00      100.00     100.00      100.00