Date great or lower and equals

[lyptikal]

Hi First post on here as i'm racking my brains

i have a formula on 2 cells to tell me if 1 date is greater than another, the only trouble is if there is a date that is the same it tells me its lower when i need it to tell me its greater

does anyone know what i can add to tell me when a date is equal and also when there is only 1 date as well as if a date is greater

Here is the formula =IF(G2>H2,"✓","X")

in my book i have it setup like this

Target Date | Appointment date
01/08/2107 04/08/2017

The formula above will tell me this is out of target

im importing info for the whole month from another spreadsheet that i need to tell me whats in target whats out of target and what doesn't have an appointment date

Any help is greatly appreciated

 

[MrKowz]

Welcome to the forums!

Try:

=IF(G2>=H2,"✓","X"

 

[lyptikal]

Thanks,

ah almost there, that has brought the dates tat are equal to in target, but the dates that dont have an appointment are still showing as appointed

almost there

 

[MrKowz]

Lets try:

=IF(OR(G2< H2,H2=""),"X","✓")

This checks to see if G2 is less than H2 OR if H2 is Blank, then return "X", else return "✓".

 

[JoeMo]

Try:

=IF(OR(G2="",H2=""),"",IF(G2>=H2,"✓","X"))

 

[lyptikal]

if it helps it displays like this


Target Appointment
[TABLE="width: 165"]
<tbody>[TR]
[TD]17/08/2017[/TD]
[TD]16/08/2017[/TD]
[/TR]
[TR]
[TD]17/08/2017[/TD]
[TD]17/08/2017[/TD]
[/TR]
[TR]
[TD]18/08/2017[/TD]
[TD]07/08/2017[/TD]
[/TR]
[TR]
[TD]18/08/2017[/TD]
[TD] -[/TD]
[/TR]
[TR]
[TD]18/08/2017[/TD]
[TD]10/08/2017[/TD]
[/TR]
</tbody>[/TABLE]

Maybe use the - symbol to trigger and different response to X and ✓

 

[lyptikal]

Hi can anyone else shed some light on the above?