Trouble with formulas!!!
Dear Vikki
Try the below using TODAY() function
=IF(K8<TODAY(),0,1)
If this post helps click Yes
---------------
Jacob Skaria
"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
|