Formula: How to write.."if A2 is blank then b2=today's date?

I need help with the syntax for the following formula in excel

Formula: How to write.."if A2 is blank then b2=today's date?

In cell B2 enter:

=IF(A2="",TODAY(),"")
--
Gary''s Student


"wheresleo" wrote:

> I need help with the syntax for the following formula in excel
>
> Formula: How to write.."if A2 is blank then b2=today's date?