How to apply more than one IF condition in 1 cell

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(a1>highestdate,1,if(a1>nexthighestdate,2,0))

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Cesar" <Cesar@discussions.microsoft.com> wrote in message
news:C63ED9F5-7662-408B-A156-943505D6146D@microsoft.com...
>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