software

CRAIGKEITH
WEEK
31-MarPET REG
07-AprPET REG
14-AprMAINPET REG
21-AprPET REG
28-AprMAINPET REG
05-MayPET REGMAIN

Ok, the above rota shows who is on call on what week. What i want to do is
have excel KNOW which shift CRAIG and KEITH are on (Early or Late) depending
on the date, and add that answer to the cell in the form of either o
conditional format or actually adding the text quot;Earlyquot; orquot; Latequot; to the cell.

Think more info amp; explanation is needed here ..

While it can be guessed that the main data:

gt; 31-Mar PET REG
gt; 07-Apr PET REG
gt; 14-Apr MAIN PET
etc

is probably sitting within A38 ?

... it's not known what PET, REG, MAIN mean
and how these are possibly related to quot;Earlyquot; / quot;Latequot;,
nor to quot;Craigquot; amp; quot;Keithquot;

In which cells a quot;Craigquot; amp; quot;Keithquot; ??
and in which cells is the indication: Early (or Late)
to be computed and placed ??

Over to you, Proddy ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Proddyquot; gt; wrote in message
...
gt; CRAIG KEITH
gt; WEEK
gt; 31-Mar PET REG
gt; 07-Apr PET REG
gt; 14-Apr MAIN PET REG
gt; 21-Apr PET REG
gt; 28-Apr MAIN PET REG
gt; 05-May PET REG MAIN
gt;
gt; Ok, the above rota shows who is on call on what week. What i want to do
is
gt; have excel KNOW which shift CRAIG and KEITH are on (Early or Late)
depending
gt; on the date, and add that answer to the cell in the form of either o
gt; conditional format or actually adding the text quot;Earlyquot; orquot; Latequot; to the
cell.
Hi Max
Sorry, but i'm a total newbie to excel, i just went through it and shaded
the cells accordingly :-)
I'm about to start on a LearnDirect course on Excel so I expect i'll be on
here quite a bit from now on.
Thank you for your reply thouh, made me realise I have LOTS to learn

Craig

quot;Maxquot; wrote:

gt; Think more info amp; explanation is needed here ..
gt;
gt; While it can be guessed that the main data:
gt;
gt; gt; 31-Mar PET REG
gt; gt; 07-Apr PET REG
gt; gt; 14-Apr MAIN PET
gt; etc
gt;
gt; is probably sitting within A38 ?
gt;
gt; ... it's not known what PET, REG, MAIN mean
gt; and how these are possibly related to quot;Earlyquot; / quot;Latequot;,
gt; nor to quot;Craigquot; amp; quot;Keithquot;
gt;
gt; In which cells a quot;Craigquot; amp; quot;Keithquot; ??
gt; and in which cells is the indication: Early (or Late)
gt; to be computed and placed ??
gt;
gt; Over to you, Proddy ..
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;Proddyquot; gt; wrote in message
gt; ...
gt; gt; CRAIG KEITH
gt; gt; WEEK
gt; gt; 31-Mar PET REG
gt; gt; 07-Apr PET REG
gt; gt; 14-Apr MAIN PET REG
gt; gt; 21-Apr PET REG
gt; gt; 28-Apr MAIN PET REG
gt; gt; 05-May PET REG MAIN
gt; gt;
gt; gt; Ok, the above rota shows who is on call on what week. What i want to do
gt; is
gt; gt; have excel KNOW which shift CRAIG and KEITH are on (Early or Late)
gt; depending
gt; gt; on the date, and add that answer to the cell in the form of either o
gt; gt; conditional format or actually adding the text quot;Earlyquot; orquot; Latequot; to the
gt; cell.
gt;
gt;
gt;

No problem, Craig
Thanks for posting back
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Proddyquot; gt; wrote in message
...
gt; Hi Max
gt; Sorry, but i'm a total newbie to excel, i just went through it and shaded
gt; the cells accordingly :-)
gt; I'm about to start on a LearnDirect course on Excel so I expect i'll be on
gt; here quite a bit from now on.
gt; Thank you for your reply though, made me realise I have LOTS to learn
gt;
gt; Craig