Trouble with formulas!!!

V

Vikki

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
 
J

Jacob Skaria

Dear Vikki

Try the below using TODAY() function

=IF(K8<TODAY(),0,1)

If this post helps click Yes
 
J

Jacob Skaria

Dear Vikki

Try the below using TODAY() function

=IF(K8<TODAY(),0,1)

If this post helps click Yes
 
R

RagDyeR

Another way:

=--(K8>=TODAY())


Regards,

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


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the =TODAY() option 3
traffic light formula 6
Conditional Formatting!!! 4
What is wrong with this formula? Please help! 2
Inserting date from formuls 2
Conditional Date formula 3
Advanced filter 7
how to calculate hrs flown in last one year 0

Top