Dear Roy,

Try this formula in V1 (say). If(countblank(AD1)=1,0,AD1)

Regards,

Ashish Mathur

"roy.okinawa" wrote:

Columns V, X, AA, AB, and AD may have dates in them that are entered
manually. Sometimes they will be left blank.

What I need is a formula that will put a zero in columns V,X,AA, and AB when
column AD has a date entered.