I dropped an F

=IF(G5<"",G5,"")


--

HTH

Bob

"whatzzup" wrote in message
...
Bob, thanks for the response....unfortunately when i cut and paste into
D5,
it return "#name?", i was expecting it to return whatever is in G1

"Bob Phillips" wrote:

D5: =I(G5<"",G5,"")

--

HTH

Bob

"whatzzup" wrote in message
...
Hi all, this is what i wish to have happen; i have created a list of
activities B5:B25 say, next to them i have two column Start & Finish D
&
E,
next to them i have columns G to J, where G1:J1 has date fields in
cells
8th
Jan 10, 15th Jan 10, to 29th Jan 10 week between them. The question is
how
can i retrurn a date in cell D5 if i populate G5 (or fill with a
colour)?


.