finding a formula to help with dates.
Hi I am trying to work out a formula to work out the following problem.
If "cell 1" is a later date then "cell 2" then "cell 3" is to be "older"
If "cell 2" is a later date then "cell 1" then "cell 3 is "the number of
days between them"
If "cell 2" has no date then "cell 3" remains blank.
If anyone can help me work this one out, I would greatly appreciate it.
Thanks.
|