I need to build a holiday calendar/table for referencing time off. This calendar though, needs to update either automatically or manually using the system date as a pivotal point in determining which holiday is the current one.
The current Holidays are as follows:
New Years Day Eve ...

When i follow the correct process entering data I get a
message "you've entered too few arguments for this
function"
When I follow the exact same process on another machine I

Can someone please help me??
I have stored an email address in a cell on various
workbooks.The workbooks are attached to an email via a
macro.

Our company have more than 900 workers with approx. 35  
different position. I need to count the total no. of each
respective position that attended the seminars.
Using "sort" will only arrange the position in

I wnat to execute an IF function which returns a value (cell content) to another cell. I like to know how If finction returns not just the cell content but also its format. e.g.
if A1=555, ( A1 is formatted so that the font is Blue)
A2=555 (A2 is formattted so that the font color ...

Excel (2000) has recently started doing something weird. When I click on
the icon to start the programme, it automatically loads a file from the
root of C: (one time it was a name.log file and now it has started doing
it with a small .jpg I have in C: temporarily.

Good day to all,
We received 5 different report from our various dept. and
we combined all these 5 files into 1. The problem here is
that some of the report had 1 or 2 spaces before they type

I am working on a worksheet that has mulitiple tabs and on one of th
tabs contsists of a pricelist that I would like the information to com
up on the other tabs.  For example:  If I place a model number in on
column and I want the price to automatically come out onto the nex

Can someone pleae show me how to convert a decimal number to  time  in
VBA
Thanks In advance
---

Just wondering, this formula was suggested and it works,
but I was curious why the two instances of using double
dashes is necessary for the formula to work.  
Formula:

The formula that follows works very well: =IF(C13="Horn",(A13),"")
What I'd like to do is have this formula reference a column range to say: =IF(C1:C61="Horn",(A1),""). take this record with "Horn", "Harber" or "Jet" as the product type as a marker/key and plug the whole record ...

I am writing a 24/7 roster. I want to automatically fill
up cells to consist the days of a month I choose from a
list.
eg. If I choose Jan 2004 from a list in cell B4, than I

While doing some auditing I noticed that the IF() worksheet function
behaves differently when it is entered as part of an array formula
(control-shift-enter) vs. regularly.
The biggest difference is what it outputs.  The regular IF() just outputs

I have an easy (hopefully) question and I cannot seem to get the formula right.  My answer needs to be a dollar figure,  not a percentage.
for example: 15% of  $400,000.00 + $30,000.00 is "blank".  ( not added to or subtracted from the total - just what is the 10%, 6% 15%, etc...) ...

Hello,
I want to reference a column in another workbook, where
the columns in that workbook keep changing (column #2
today is column #5 tomorrow).  The answer is named ranges.