Trouble with formulas!!!
=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
|