I have an issue that I am trying to resolve with excel function.

Basically I have three columns and all I want is when a user insert a value into one of these columns, the days date is inserted into column B to record the day of insert.

I tried this function for one of the columns:

**=IF(B3<>"";IF(B3="";TODAY();B3);"")**and it works fine. But I want to extend this for the rest columns, but cannot get it to work with the function below.

=IF(OR(D3<>"";IF(B3="";TODAY();B3);"";IF(OR(F3<>"";IF(B3="";TODAY();B3);"";IF(OR(H3<>"";IF(B3="";TODAY();B3);"")))

=IF(OR(D3<>"";IF(B3="";TODAY();B3);"";IF(OR(F3<>"";IF(B3="";TODAY();B3);"";IF(OR(H3<>"";IF(B3="";TODAY();B3);"")))

I would really appreciate your help guys....Thanks