Trouble with formulas!!!
 

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

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

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

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

Trouble with formulas!!!
 

Thank you that is perfect!!!

"Jacob Skaria" wrote:

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

Trouble with formulas!!!
 

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

Trouble with formulas!!!
 

Thank you that is perfect!!!

"RonaldoOneNil" wrote:

=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

Trouble with formulas!!!
 

Another way:

=--(K8=TODAY())


Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------


"Vikki" wrote in message
...
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