Working with Excel 2000. My workbook has four worksheets. Worksheet 4 is a summary of some of the cells in the first three. One employee may only be required...

Interval Date of in years Finding Plus 1 year IF today Date 0.5 11/4/2002 11/4/2003 5/4/2004 Format Number 36103 36468

Interval Date of in years Finding Plus 1 year IF today Date 0.5 11/4/2002 11/4/2003 5/4/2004 Format Number 36103 36468

Hi I am trying to calculate Years of Service with the dates given below. Is there a formula to take "Start Date" and "Job End Date" and get Years of Service?...

Is there any way to disable that pop up warning that warns you, as you start an excel workbook, about how some macros can contain viruses. I would just rather...

Greetings, I am attempting to incorporate a simple formula into a spreadsheet and it's not cooperating. ="As of "&TODAY() The problem is that no matter what...

I have created a link to sheet 1 in a workbook. I want to copy the link to the next row down, but I don't want it to go to the next cell down in sheet 1, I...

How in the world do I add 10 to 50 different numbers (in different cells)at the same time?

I am using data validation to make a list box with several categories. After the category is selected, it populates the next list box using VLookup. However,...

I would like to be able to do date math on dates from the previous century, however these dates are all treated as text. I can change the appearance of the...

I want to join two columns of data into one. The first column has this data: 18000. The second column has data similar to this but of varying values like...

Is there a way to compare excel files with the differences highlighted as in "Word"?

I have two cells I want to concatenate and keep the leading zeroes of the second cell. (e.g., first cell is 201, second cell is 245 which has been formatted...

=COUNTIF(rng,"No Report") -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays "George" wrote in...

I have a column of numbers. I want to count the occurences within different ranges of numbers (like between 40 and 50). I've tried the formulas below but they...

hi i have a cashflow spreadsheet that monitors how much money=20 i owe and how much i have already paid. there are two=20 columns of the data i want to...

I am trying desparately to set up the folowing: I need data validation on with a dropdown list - simple enough. But, the values in the list are codes (i.e...

Please Help I think this is quite easy for most but for some strange reason i cant get my head around it. I have a range of cells in a collumn that are...

Nick, Whatever you see in the Data Validation will, I fear, be what it puts into the cell. I think it will require a macro (event macro that...

How would I go about finding the cells involved in a circular reference, in a spreadsheet that has LOTS of formulas, when Excel is giving me the error message...