IF Function

[henriques]

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

 

[T. Valko]

2ª

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

 

[Pete_UK]

Biff,

it returns a CODE of 170, and does look like lower case a when copied
into Excel (and zoomed).

Pete

 

[henriques]

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]

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",

 

[henriques]

Thanks Walco, it works onderfull

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",

 

[T. Valko]

You're welcome. Thanks for the feedback!