How can I construct a formula that will relate TODAY to the 1st Tuesday of each month. For example as today is 01/12/07, my formula should return...

There are no built in functions but there are other ways http://www.cpearson.com/excel/colors.htm -- Regards, Peo Sjoblom

I am confused, why does Microsoft have two excatly alike products on the market? Office XP and Ms. Works? Works is is around $50 and MS Office XP sells for...

Hello. Does anyone know how to use a statement or a function that calculates how many days are remaining from a start date to a due date, but excluding...

I have a column with the following dates: 11/23/05 11/23/05 11/23/05 11/25/05 11/25/05 11/28/05 12/1/05 12/1/05

Does anyone know of a formula that will calculate how many days are from one date to another? For example from March 30 to April 8. This is for the purpose...

Hi, Having a bit of difficulty constructing a formula to work out the following: We have a table of dates and a 'category' roughly as follows: Start Date #...

I'm PHP/JavaScript programmer, so please bare with me as I'm not all to fimilar with Excel's way of doing IF and ELSE, MATCHing and such. I rarely use Excel by...

I have some outliers in a set of data, and would like another method, besides the TRIMMEAN to smooth the outliers. Trimmean "eliminates" the outliers... how...

Have you tried Sumif() sumif(b1:b100,"=A",c1:c100) Lance -----Original Message----- I have a problem with excel. I have a list of expenses, sorted by...

I am using the following formula to get an average for a column of data where the values are greater than or equal to the value...

Hi, I need some assistance with tracking my commissions that are due to be paid each month. The "Comm Due Date" is in column "C", rows 3 - 30 which list by...

Can you split a worksheet in half vertically, but scroll vertically on both?. For example, have cells j1..l8 stay put, when scrolling up cells a1.I100 ? It...

I have excel 2000. I am trying to get this formula to work. It does not give me any errors or anything It just will not return the number in the cell that it...

Need to create several spreadsheets ... each containing multiple worksheets .... Example: Monthly spreadsheets containing a separate worksheet for each day of...

Is there a way to not have a blank or zero value not be counted in an average function. Example: I have a spreadsheet that has a year's worth of data. ...

Does anyone know an easy way to hyperlink from Excel to a specific slide (say Slide 59) in a PowerPoint file using the hyperlink worksheet function. Thanks for...

Hi From a previous post I was provided with a formula to provide a year to date total from a table based on the month I entered in...

On opening a excel workbook, is it possible to have a default way of opening? For example, I want to display a certain worksheet everytime on opening that...

Hi. I am trying to get a sumproduct formula that will look at the date in one column and if its the correct month, total values in a second column. I am...