I have to calculate the week number for a given date but the catch is
the week has to work from FRIDAY to THURSDAY.
Using the WEEKNUM function is great for a Sunday or Monday start. Is
there a simple solution??

Thank you in advance for your help.
I have an address label file in .rtf format. It has 3 X
10 labels on one page totally about 14,000 address
labels. I wanted to convert it into MS Excel 2002 so i

When I use Autofill to copy down formula, it shows the
result od the copied cell in the new cell. But when you
click on the cell it shows the correct formula in the
Formula Bar. So basically the formula is correct and has

I'd like to round the answer in an elapsed time field to
the nearest 15 minutes.
i.e. Total elapsed time = 25:11 should read 25:15 and
25:07 should read 25:00 after rounding.

I have 1 report file and another file with two data
worksheets.
This formula works for 1 of the data worksheets; however,
I want it to look in the other worksheet if it does not

   I have raw data in a colum which is the following format eg.20/11/2003
16:23 for date and time. I need to extract a value which is either Day,
Evening or Weekend depending on the date and time. I need day to run from
8:00am to 18:00pmMon-Fri, evening to go from 18:00pm to 8:00am ...

could anyone tell me how to view two spreadsheets that are in the same workbook at the same time?

Hi :)
Ok the way i am doing this currently is, to be blunt, rubbish.
Thus i am hoping someone could help me out here.
Basically i click on a button that loads up a userform and in it are

I have a list with values such as:  
Buy
Sell
Settle Buy-Child

I'm using this formula: =IF(OR(L15=0<7),1,"FALSE") and I get the same "FALSE" answer when L15 is 4 and when it is 0. Could someone point out my error? Thanks

I (trie to) use excel as a tool to convert customer data and export them to a new program. The worksheet contains data importet from a text file, witch in turn was exportet from an acconting program. My aim is to make a ; delimited file (dont know the english word for that sign). ...

I have converted a formula from 1-2-3 to Excel, and I have
a problem:
@STRING(E24;0) is transferred to
(FIXED(E24;0;TRUE)

I am currently using dat validation with the in-cell drop down list and Ignore blanks checked.
The list a list of valid cost centers, currently in the neighborhood of 37000 items. Question: When I set the maximum limit of row range to 32767 works fine, beyond that data does not ...

I'm trying to build a drop down list into a worksheet and
am not sure how to do it, of if Excel is even capable of
doing it.  The list will have around 30 entries in it,
with each entry related to a value in another cell.  Can

In three instances I have used this formula successfully to calculate an age in years: =SUM(J19-C1)/365. J19 & c1 are formatted as dates and the answer cell is formatted as a number. When I try to use the same set up in subsequent cells the answer returned is "#value". If I ...