I periodically have a situation where I know the ages of a list of people and
need to convert the ages into birthdates.  
i.e.  Age 43 - instead of manually calculating that this persons birthday is
approximately 1/1/1964, how do I enter a formula to change the age into a

I would like to edit the template to suit my purposes.  Does anyone know the
password to unprotect the sheet?  Or is there a way to do a "Save As" and
remove that protection?

How do you write a formula in 1 worksheet that contains data in another
worksheet?  Both worksheets are in the same workbook.
Thanks for the help!

I want to be able to use a range reference of cells as text in one cell by a
function in another cell.  I can create the range using CONCATENATE (e.g.,
A310:A320) which will appear as text in a cell, but I can't seem to use this
in another function call.  Does anyone know how to ...

I have a workbook that is open constantly on our helpline wallboard. A
couple of the cells point to other cells in a different workbook which
we update daily.
My problem is that when we make the updates the sheet on the wallboard

Using Excel 2003
I have a range of cells from A1 to A20 that has conditional formmating. If
someone enters a number from zero to 4.5, the background turns green.  The
problem is, before someone even enters a number, the background is green. Why

I'm, using lotus notes for mailing service. Earlier I was using office XP.
Since I have switched over to office 2003, the button on my tool bar for
"Sent to mail recepient (as attatchment) is switched off. I cant click it. I
have changed the setting in my internet explorer to use ...

Basically I need to calculate the number of dates in a column which have an
earlier date than todays date. If you look at my below attempt it might
better explain what I'am trying to achieve: -
=countif(B5:B100,"<Today()")

I'm trying to use the HLOOKUP formula for the following scenario:
Lookup value is a reference cell (B8)
Table_Array is the range of cells (B15:E15)
Row Index Number is 1

I cannot figure out how to use the Proper Function in a macro that runs
my spreadsheet. I need the out put to be normal and not all caps. The
users, use all caps because they are too lazy to hit the shift key.
I have 12 sheets, one for each month with 12 columns and 200 rows per

I have tried the function and played around with it abit but no luck,:
=IF('Events Due August'!B2:B1206,$C$3,SUMPRODUCT(--('Events Due
August'!F2:F1206='Customer Data Sheet'!B7))).
So I'm looking for the total number of events for a specific event

I am trying to do a Vlookup that would automatically refer to a different
sheet in a workbook. I have a workbook called January08.xlxs with 31 sheets
called 1-1 to 1-31 respectivally. I would like to do a vlookup on cell D7 and
have it return the contents of sheet 1-1in the D8 ...

instead of reenventing the wheel I turn to this group with my case:
assume a single column consisting of 20 cells; now, 11 cells contain the
number 1, others are empty. What I'm looking for is an elegant way of
elaborating all possible combinations of these 11 pieces as how they ...

All three cells listed in the formula below are dates.  If there is data in
cell R9, that cell should be calculated as below.  If 01/00/00 is listed in
R9, the formula should calculate R4 in the same manner.  I have started with
the following formula, but obviously have not ...

I have a large array (startingHoles).   Next to te array I have a column
containing a formula  This formula needs to know the relative row of the
array it's next to for use in the formula.
Here is the formula: