Groovy Chick
Board Regular
- Joined
- Oct 10, 2017
- Messages
- 75
- Office Version
- 2016
- Platform
- Windows
Hi, I have a spreadsheet and need to create a formula that will address the following arguments but I am not sure where to start:
If the date in column D is greater than column H then text to return is "Not on Time"
If column D is blank and column H is less than today then text to return is "Not on Time"
If the date in column F is greater than column H then text to return is "Not on Time"
If column F is blank and column H is less than today then text to return is "Not on Time"
Otherwise text to return is "On Time".
I wonder if anyone can help me? Many thanks in advance.
If the date in column D is greater than column H then text to return is "Not on Time"
If column D is blank and column H is less than today then text to return is "Not on Time"
If the date in column F is greater than column H then text to return is "Not on Time"
If column F is blank and column H is less than today then text to return is "Not on Time"
Otherwise text to return is "On Time".
I wonder if anyone can help me? Many thanks in advance.