View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
chriswilko chriswilko is offline
external usenet poster
 
Posts: 7
Default Trouble with formulas!!!

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