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"
[TABLE="width: 500"]
<tbody></tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Monday, August 01, 2016[/TD]
[TD][/TD]
[TD]Tuesday, August 02,2015[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

Examples: If C3 = "Tuesday, August 02, 2016" and F3 = "Tuesday, August 02,2015" then the return value would be "1"
[TABLE="width: 500"]
<tbody>[TR]
[TD]Tuesday, August 02,2015[/TD]
[TD][/TD]
[TD]Tuesday, August 02,2015[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

Examples: If C3 = "Wednesday, August 03, 2016" and F3 = "Tuesday, August 02,2015" then the return value would be "1"
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 210"]
<tbody>[TR]
[TD]Wednesday, August 03, 2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 210"]
<tbody>[TR]
[TD]Tuesday, August 02, 2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]


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"
[TABLE="width: 500"]
<tbody>[TR]
[TD]Monday, August 01, 2016[/TD]
[TD][/TD]
[TD]Tuesday, August 02,2016[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

Examples: If C3 = "Tuesday, August 02, 2016" and F3 = "Tuesday, August 02,2015" then the return value would be "1"
[TABLE="width: 500"]
<tbody>[TR]
[TD]Tuesday, August 02,2016[/TD]
[TD][/TD]
[TD]Tuesday, August 02,2016[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

Examples: If C3 = "Wednesday, August 03, 2016" and F3 = "Tuesday, August 02,2015" then the return value would be "1"
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 210"]
<tbody>[TR]
[TD]Wednesday, August 03, 2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 210"]
<tbody>[TR]
[TD]Tuesday, August 02, 2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]


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