try something like this
=if(a1highestdate,1,if(a1nexthighestdate,2,0))

--
Don Guillett
SalesAid Software

"Cesar" wrote in message
...
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