Hello,
I have a problem of finding this formula,:confused:
I eloborate my question to 3 parts:-
1. I want to compare between Date1 and Date2 which one is the latest,
2. Lets say Date2 is the latest,then i want to compare it with Date3 wether
the length between Date2 & Date3 was 5 days.
3. If the length less or equal to 5days, it will write '1' to colum A
and if more than 5days ,it will write '1' to colum B
example:
--Date1---------Date2---------Date3--------------A-------B
12/10/2006----11/10/2006---16/10/2006-----1-------
17/10/2006----10/10/2006---22/10/2006----- -------1
can anybody help me..please
Regards;
Hisham:)