View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Redsphynx Redsphynx is offline
external usenet poster
 
Posts: 22
Default 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.