You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"henriques" wrote in message
...
Thanks Walco, it works onderfull

"T. Valko" wrote:

I tried with nasted IF and it works except for the Holiday.

OK, if you have something that works up to that point then you just need
to
add to it.

List the holiday dates in a range of cells.

J1 = 12/1/2008
J2 = 12/8/2008
J3 = 12/25/2008

Assuming your dates for the month start in cell A1.

Then add this to the *beginning* of your current formula:

=IF(COUNTIF(J$1:J$3,A1),"H",

--
Biff
Microsoft Excel MVP


"henriques" wrote in message
...
It's a caracter used in Portugal to shorten some words like week days.
We
use
as well caracter º for ordinal numbers, first we write 1º. But forget
the
caracter and use the normal "a"

Thanks

"T. Valko" wrote:

2ª

What is that superscript character after the number? With my poor
eyesight,
it looks like a lowercase "a". What does that mean?

--
Biff
Microsoft Excel MVP


"henriques" wrote in message
...
In each line of column A of spread sheet is day of the month in
format
ddmmyyyy. I need that in column B appears 2ª for Monday, 3ª for
Tuesday,
4ª
for Wednesday, 5ª for Thursday, 6ª for Friday, S for Saturday, D for
Sunday
and H for Holiday. I tried with nasted IF and it works except for
the
Holiday. Please assume month of December with Holidays at 1st
December,
8th
December and 25th of December.
Thanks for help