software

i have 3 dates referring to a period and where i want under the formula cells
to have the following
if the value of the header of the table which is dats is between the first 2
dats than 1 for true and 0 for false and if the date in the header is between
the 2nd and third date than 2 for true and 0 for false

what is the formula

try something like this
=if(a1gt;highestdate,1,if(a1gt;nexthighestdate,2,0))

--
Don Guillett
SalesAid Software

quot;Cesarquot; gt; wrote in message
...
gt;i have 3 dates referring to a period and where i want under the formula
gt;cells
gt; to have the following
gt; if the value of the header of the table which is dats is between the first
gt; 2
gt; dats than 1 for true and 0 for false and if the date in the header is
gt; between
gt; the 2nd and third date than 2 for true and 0 for false
gt;
gt; what is the formula