Im currently working on a project with the excel however I'm totall

stuck on formulas/function that i needs.

(1)I need to 'ASK' execel to 'TYPE' "X" or "Y" on the base of what yea

did a job started, e.g rewiring, central heating etc.

I have tried this:-

=if(or(g10<$a$1,g10<$a$s),"X","Y")

(a1=01/04/2005)

(b1=31/03/2005)

It will work only if a job has started, if no job star, then a "X" o

"Y" will appears, how do we get the function to work only when a jo

started please?

(2)

There is another one that I'm stuck with, if a date has been input i

a1 with =a1 in colunm b1, a date will appear but if N.W.R (no wor

require) or D/C (disclaimer), then N.W.R and D/C will appear in b1, i

there a formulas/function that will work for only DATE, not text? Mak

any sense? if not, let me know i can see if i include attachment(??)

TA:confused