::: Problem with "if between two dates" :::

[infojacques]

Hello,

I have a problem with "if between two dates".

My problem is describe into the following Excel file http://cjoint.com/?hpqqXE0lBq

Could anyone help me?

Many thanks in advance.

Jacques

 

[Mark]

I looked at your sheet and I came up with the following formula:

=IF($B$14<C19,"Too Late",IF(AND($B$14>C19,$B$14<C18-1),"Exit Now",IF($B
$14>=C18,"Not Yet",FALSE)))

I had a bit of trouble understanding your question but I think this is
what you wanted.

Hope that helped
Mark

 

[infojacques]

Hi,
I will try your solution.
It looks very good, I think you understood it perfectly.
Sorry for my Englsih ...
Thanks again and take good care !
Jacques