Date Based IF Formula Assistance Needed

[BishopDesigns]

Here is what I wrote but it is not functioning quite right

=IF((AND((F3=NOW()-1),C3>=F3)), "1", "0")

What I want to happen is if C3's date is equal to or after the value of F3's date I get a value of 1

Examples: If C3 = "Monday, August 01, 2016" and F3 = "Tuesday, August 02,2015" then the return value would be "0"

<tbody></tbody>

Monday, August 01, 2016

Tuesday, August 02,2015

0

<tbody>
</tbody>

Examples: If C3 = "Tuesday, August 02, 2016" and F3 = "Tuesday, August 02,2015" then the return value would be "1"

Tuesday, August 02,2015

Tuesday, August 02,2015

1

<tbody>
</tbody>

Examples: If C3 = "Wednesday, August 03, 2016" and F3 = "Tuesday, August 02,2015" then the return value would be "1"

Wednesday, August 03, 2016 <tbody> </tbody>

Tuesday, August 02, 2016 <tbody> </tbody>

1

<tbody>
</tbody>

Any Assistance would be great!

Thank you in Advance!

 

[JoeMo]

Try:
=IF(C3>=F3,1,0)

 

[BishopDesigns]

No Go When I have C3 "Tuesday, August 02, 2016" (which is text based) and F3 "Tuesday, August 02, 2016" (which is formula based =NOW()-1) the return value is "0" and I need it to be "1"

Thank you though!

 

[BishopDesigns]

Solved it! I need to change the F3 formula from =NOW to =TODAY

Here is what I wrote but it is not functioning quite right

=IF((AND((F3=NOW()-1),C3>=F3)), "1", "0")

What I want to happen is if C3's date is equal to or after the value of F3's date I get a value of 1

Examples: If C3 = "Monday, August 01, 2016" and F3 = "Tuesday, August 02,2015" then the return value would be "0"

Monday, August 01, 2016

Tuesday, August 02,2016

0

<tbody>
</tbody>

Examples: If C3 = "Tuesday, August 02, 2016" and F3 = "Tuesday, August 02,2015" then the return value would be "1"

Tuesday, August 02,2016

Tuesday, August 02,2016

1

<tbody>
</tbody>

Examples: If C3 = "Wednesday, August 03, 2016" and F3 = "Tuesday, August 02,2015" then the return value would be "1"

Wednesday, August 03, 2016 <tbody> </tbody>

Tuesday, August 02, 2016 <tbody> </tbody>

1

<tbody>
</tbody>

Any Assistance would be great!

Thank you in Advance!

 

[mole999]

Now will return and integer and a decimal, so Now() is different to Now(), it won't mean a defined date is measured as a date so it will never match

 

[Margild8a]

if the value on C3 is text based, can you try to convert the NOW() value to text using =TEXT(NOW(),"DDDDD, MMMM dd, yyyy")

check if this works