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![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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![Eek! :eeek: :eeek:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
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
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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
![Eek! :eeek: :eeek:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)