I have a start date that varies - and I need a formula that populates the
first Tuesday each month. I have tried several different formulas but they
all get messy due to some months being 4 weeks and others 5 weeks. Any
suggestions on which formula to try? Thanks so much!

Is it possible to have a conditional format occur if a linked cell is
highlighted?
Thank you

Hi there.  I'd like to type postal codes this way:
b3j2m7 and have a formula that would change it to:
B3J 2M7
What options do I have?  Thanks.

I need to copy a range from sheet 1 to sheet2 and copy it directly
below a cell that eqauls a cell value on sheet1.
So if Sheet1 Cell A1 equaled 7:00 AM I would want the range copied to
sheet2 directly below the Cell with a value of 7:00 AM in it.

is there a way to give points by a function ?
and in english, sport results (points) in excel sheet, let's say varying
from 10 to 100 and I would like to give them points from 10 down. meaning
that the best player (biggest points) would get 10 points, next biggest

How can I get the cells to populate with the dates of the 1st Tuesday of the
month?
I tried =C26+7+7*(MONTH(C26+7)=MONTH(C26)) but that gives me every Tuesday.
Thanks.

How do I make my worksheet chg the row color to a specific color if a cell
equals 100%, but if the cell is between 1 - 99% chg the row color to a
different color.

I am trying to do a sumif using two criteria. I thought I might be able to
combine a Sumif with And:  but that didn't work.
I'm trying to sum m4:m80 but only cells where both they and the cell beside
them in N4:n80 are both <0.

I would like to look-up a cell's value in a range of cells and return 1 if it
exists or zero if it does not exist in the specified range. I have got to
believe this is a fairly common need. Can anyone help me out with this.

Does any one know how to add a word to the Excel database so it will
recognize it?

I have a start date of 11/1/2008 - What I want to populate is a table that
has columns for Jan-08, Feb-08, Mar-08 etc begining with January ending with
December.
I know I can type the column headers, but I want the column headers to

Does this formula produce a fraction consistent with part of the day count
using 365 days and part of the day count using 366 days when the start date
the formula references is in a 365 day year and the end date is in a 366 day
year and vice versa?

I have about 5 worksheets in 1 workbook-- the first sheet is a summary sheet
that summarizes all 5 sheets on a separate line.  for Example Sheet 1-- I
summarize by the total count of orders; the orders over 10 days old and those
over 5 days old.  I then do the same for the rest ...

I am a meeting planner and regularly get arrival information from my clients
in miliatry format - sometimes even without a colon.  I am trying to make a 4
digit
number already on a spreadsheet into a time format.  Does anyone know how?

i need to know when 2 dates intersect
1-i begin with todays date and add a variable to it
2-i then subtract the same variable from a future date
3-i need to know at what date the 2 intersect