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
 
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

Transfer data between two tables 3
Use TODAY() function as the criteria in a SUMIF formula 1
Using the =TODAY() option 3
Drop down list control value in vba 2
Conditional formatting with dates 7
Justification function versus wide spaces 0
Newbie Help - IF Yes No Function 0
Doughnut Chart linked with the slicer in the pivot table 0

Top