Kayos
Gone......
- Messages
- 8,986
- Location
- Yorkshire
I'm getting better but this one has got me stuck. I'm sure it's simple but I just can't quite get it right.
I need to compare 2 dates, and output the result in a 3rd cell
If date A is before B it needs to return No
If date A is after B it needs to return Yes
If date A is filled in but B is blank it needs to return Yes
B shouldn't ever be filled in without A but if it is the output cell should either return No or be blank
I'm sure that's as clear as mud.....
I need to compare 2 dates, and output the result in a 3rd cell
If date A is before B it needs to return No
If date A is after B it needs to return Yes
If date A is filled in but B is blank it needs to return Yes
B shouldn't ever be filled in without A but if it is the output cell should either return No or be blank
I'm sure that's as clear as mud.....