Hi all,
I have two date columns:-
Column A is action date and B is completed. A will always have date and B only when completed.
What I would like to do is have an IF statement that looks at if column B is empty and A is less than today = "Pending" or if B is not empty and is less than A than "completed" or if B is not empty and B is higher than A than "out of time".
A will always have date in it.
I manage to do the IF but tried AND with ISBLANK but kept hitting error
Thanks
I have two date columns:-
Column A is action date and B is completed. A will always have date and B only when completed.
What I would like to do is have an IF statement that looks at if column B is empty and A is less than today = "Pending" or if B is not empty and is less than A than "completed" or if B is not empty and B is higher than A than "out of time".
A will always have date in it.
I manage to do the IF but tried AND with ISBLANK but kept hitting error
Thanks
