Hi,

I will like to use colume B (enter date) to trigger the change Column A (start from Row 3 onward) with formula "=Text (RC1,"DDD")". If colume B is empty, colume A will show nothing (eg. B4 is empty and A4 is empty as well, while B5 is occupied and A5 will show the Day)

If not mistaken, SheetChange () will trigger the change as long as there is changes in B column start from B3. Please help on the VBA code as I have no idea how to write it.

Thanks in advance


                  Column
 Row
 1              
 2                 A (Day)             B(Date)
 3              =text(RC1,"DDD")      11 Nov 13
 4
 5              =text(RC1,"DDD")      11 Nov 13
 6
 .
 .
 9999          =text(RC1,"DDD")      11 Nov 13
Best regards,
KC