Hieveryone, I am an excell novice trying to put together a project calculation sheet. I need to calculate total days between 2 dates excluding each and every...

Is there a way to set up color conditional formatting for 5 different conditions in Excel 2000?

Does anyone know if it's possible to find the TWO minimum values in a range? I know how to use MIN to find the first, but is there any way to find a second...

We have workbook that uses the GEOMEAN function on a column of data. The values being analyzed are returned by the formula =IF(M1=0," ",M1) to ensure that...

I am needing to build a rolling 5 day work week calander. I want it to always show the current work day first then the next 4 work days. It needs to skip...

I need a way to find the cell containing ":" in a row and copy it to a new column. I would think it should be simple, I just can't figure it out right now.

I'm doing a spreadsheet and would like some help. I want the foumula to comapre one cell and if it has the gift in it and the next cell over is below 40 then...

I am trying to create a formula in which excel searchs an array of alpha + numeric values for a number 0 and if true, marks the formula's cell with an "X". I...

I need to freeze several rows at the top of my spreadsheet and several at the bottom so that both the top and bottom remain in view whilst a user scrolls...

How do I calculate the difference between the current date and time and a future date and time. I want the sheet to insert the current date and time (which I...

I'm having trouble with a "VLOOKUP" formula. I use Excel to open a text file where the text is separated by spaces. I go through the motions of establishing...

Is there a function in Excel that can return the coefficients of a polynomial from a set of X values and a set of Y values? I know you can get a trendline...

I've been trying to come up with a formula/macro to do this for a long time but I can't seem to figure it out. You all seem very knowledgeable so maybe you can...

I want to create a formula on Sheet1 that will give me the SUM of all values on Sheet2 column G where the value in column B is = "x". I think I need to use...

This has got to be very simple but I can't seem to figure it out... On Sheet1 "A1" I have "=Sheet2!A1" On Sheet1 "B1" I have "=Sheet2!A2" On Sheet1 "C1" I...

I'm trying to create a sprdsht that will give me the number of Saturdays and Sundays based on inputs of Starting Date and Ending Date. It's a nut i haven't...

I am having trouble trying to save an Excel spreadsheet using a delimiter other than tab or comma. I received a text file which uses the pipe | as the...

I have two Excel files which I want to Merge together on the cell PatientID into another Excel file (Starting Empty). The tool box has a command 'Compare and...

Is there a way to limit the number of times a workbook can be opened? The idea is to update a spreadsheet (workbook) template every few months. I would...

How do I add business days to a date to get another date? For example: A1 = 4/08/2004 B1 = 5 Add A1 and B1 to get C1 = 4/15/2004? This is sort of the...