Thread: between dates
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default between dates

=IF(AND(StartDate=OpeDate,OpeDate<=EndDate),4.50% *Amount,0)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"thanks" wrote in message
...
Hello,

I have the following information:

Ope Date Ammount Start Date End Date
09/11/2006 5.000 09/11/2006 09/11/2007

In the first year you charge 4.50%
If I need to muply the ammount with the %change IF the operation date is
between the start and the end date, haw should I write the formula?
IF(StartDate=OpeDate<=EndDate, 4.50%*Ammount,0)...this didnīt work!

Please help as soon as possible!