warning with concatenated date
 

I'm making a table with double entry, that gives me one date. Cos the axis X,
are year, axis Y, are Month, and the cross of that 2 are the day.
With conditional format i know that i can put a warning that reaching near
of that date it would be activated.
My problem is how to extract that date to do the comparison.
I'm triyng with concatenate, but i'm not getting that can anyone help me?

warning with concatenated date
 

If say B1 = Jan, C1 = Feb, etc
A2=2006 say
if B2 is day

then select the day fields starting at B2 and use a CF formula of

=AND(TODAY()<DATEVALUE(B2&"/"&B$1&"/"&$A2)+5,TODAY()DATEVALUE(B2&"/"&B$1&"/
"&$A2))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Micos3" wrote in message
...
I'm making a table with double entry, that gives me one date. Cos the axis
X,
are year, axis Y, are Month, and the cross of that 2 are the day.
With conditional format i know that i can put a warning that reaching near
of that date it would be activated.
My problem is how to extract that date to do the comparison.
I'm triyng with concatenate, but i'm not getting that can anyone help me?

warning with concatenated date
 

It worked just fine!!!
i applied to the formula below:
=if(today()<(datevalue(b2&"/"&b1&"/"&a2)-5);"Test";"Miss 5 Days...")

Now another problem has appeared, that is b1 and b2 depend where the day is,
because it can be in january but it can be in february, so i guess i need to
have a function (i only remember the portuguese name "proch" something like
search in line) to give back the day(b2), and the month(b1) with only this
formula.
At first sight, i will have only one date for every 12 months in any
register, so this formula needs to be like this, to adapt to every situation.
Can give me some help substitute b2 and b1 in formula for this function that
i name for?

Thanks again!!!



"Bob Phillips" escreveu:

If say B1 = Jan, C1 = Feb, etc
A2=2006 say
if B2 is day

then select the day fields starting at B2 and use a CF formula of

=AND(TODAY()<DATEVALUE(B2&"/"&B$1&"/"&$A2)+5,TODAY()DATEVALUE(B2&"/"&B$1&"/
"&$A2))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Micos3" wrote in message
...
I'm making a table with double entry, that gives me one date. Cos the axis
X,
are year, axis Y, are Month, and the cross of that 2 are the day.
With conditional format i know that i can put a warning that reaching near
of that date it would be activated.
My problem is how to extract that date to do the comparison.
I'm triyng with concatenate, but i'm not getting that can anyone help me?

warning with concatenated date
 

Hlookup function.
I'm trying to make it work but i'm not getting...

"Micos3" escreveu:

It worked just fine!!!
i applied to the formula below:
=if(today()<(datevalue(b2&"/"&b1&"/"&a2)-5);"Test";"Miss 5 Days...")

Now another problem has appeared, that is b1 and b2 depend where the day is,
because it can be in january but it can be in february, so i guess i need to
have a function (i only remember the portuguese name "proch" something like
search in line) to give back the day(b2), and the month(b1) with only this
formula.
At first sight, i will have only one date for every 12 months in any
register, so this formula needs to be like this, to adapt to every situation.
Can give me some help substitute b2 and b1 in formula for this function that
i name for?

Thanks again!!!



"Bob Phillips" escreveu:

If say B1 = Jan, C1 = Feb, etc
A2=2006 say
if B2 is day

then select the day fields starting at B2 and use a CF formula of

=AND(TODAY()<DATEVALUE(B2&"/"&B$1&"/"&$A2)+5,TODAY()DATEVALUE(B2&"/"&B$1&"/
"&$A2))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Micos3" wrote in message
...
I'm making a table with double entry, that gives me one date. Cos the axis
X,
are year, axis Y, are Month, and the cross of that 2 are the day.
With conditional format i know that i can put a warning that reaching near
of that date it would be activated.
My problem is how to extract that date to do the comparison.
I'm triyng with concatenate, but i'm not getting that can anyone help me?