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