IF Function
 

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

IF Function
 

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

IF Function
 

Biff,

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

Pete

On Dec 18, 11:21*pm, "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- Hide quoted text -

- Show quoted text -

IF Function
 

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

IF Function
 

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

IF Function
 

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

IF Function
 

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