If there will be nothing else in column A except either dates or a blank
cell, then this in B1 and copied down will do..

=IF(A10,1,"")

If column A could contain either TEXT or a date or blank, then this

=IF(AND(ISNUMBER(A1), A10),1,"")

If column A could also contain numbers, then only specific date ranges
"might" be identified....as just the number 1 can actually be formatted and
considered a "date"...



Vaya con Dios,
Chuck, CABGx3


"novice33" wrote in message
...
I am trying to create an If statement that would populate a 1 in another
cell
by reading the date in the cell next to it. For example, in cell A2 I
have
12/12/2005, I want cell B2 to populate with a 1 if there is a date. More
or
less, every time a date is entered in Column A, I want Column B to have a
1
next to it. I would appreciate any help given.