Hello,

if you do ...
=IF(((TODAY()-WEEKDAY(TODAY(),2))<$A2),$A$1,"")

If this is true you return the info in cell A1 otherwise it returns nothing.
--
Kevin Smith :o)


"Dave" wrote:

Hi,

lI have a formula that returns a TRUE or False statement. If the statement
is TRUE I want the cell to show the TITLE of the column. How do i do this.
The current formula is:

=((TODAY()-WEEKDAY(TODAY(),2))<$A2)

Thanks