Thank you that is perfect!!!

"chriswilko" wrote:

Use:

=if(k8<today(),0,1)



"Vikki" wrote:

Hi there

I am trying to create a formula in excel 2003. If the date shown in cell K8
is before todays date, I want it to return a value of 0 and if the date shown
is today or later I want it to return a value of 1 - can anyone please help???

Many thanks in advance

Vikki