Hi Eric,

Maybe you could try putting the date in a separate cell and giving a cell
reference to this one in the IF function. Hope this works!

Regards,
Karthik

"Eric" wrote:

Does anyone know how to add date format into if statement? such as
If(A1="1-Mar-2005", 1,0)
Thank you
Eric