Need a formula to add bonuses based on calendar dates

[KC2MF]

I'm trying to add bonuses based on whether an event meets a certain window of time in a regular calendar year (Jan-Dec). For example such as . . .

create a 5% bonus for all events occurring between April 1st and April 31st (starting and ending dates inclusive)

What formula would be needed or necessary to make determining event-timed bonuses (or even deductions) based on existing dates of events.

Thanks again for the help in advance.

 

[texasalynn]

so how would your data be laid out? What column is the event data shown? Would the bonus be given on everything, just dependent on the dates?

 

[texasalynn]

here is a sample

Excel Workbook
	C	D
1	4/1/2011	4/30/2011
2	0
Sheet2

Excel 2003

Cell Formulas
Range	Formula
C2	=IF(AND(A2>=$C$1,A2<=$D$1),5%*1000,0)

 

[KC2MF]

What I'm hoping to do is have a one-in-all formula that I can apply to all the fields based on there occurrence. For instance . . .

Group 1: 3 Shares (Occurs on 01/03/2011)
Group 2: 7 Shares (Occurs on 05/31/2011)
Group 3: 18 Shares (Occurs on 07/07/2011)
Group 4: 4 Shares (Occurs on 09/30/2011)
Group 5: 10 Shares (Occurs on 12/28/2011)

And the criteria for placing bonuses or maturities on these groups based on their event timing is say . . .

Period 1: 01/01/2011 - 01/31/2011 (no bonus awarded)
Period 2: 02/01/2011 - 03/31/2011 (a 5% bonus in shares is awarded)
Period 3: 04/01/2011 - 06/30/2011 (a 10% bonus in shares is awarded)
Period 4: 07/01/2011 - 12/31/2011 (a 15% bonus in shares is awarded)

Beginning and End dates are included in the period time-frames. So the add-on would be a multiple of the shares they already have. Group 5 has 10 shares and occurs in Period 4 therefore they get an additional 1.5 shares for their late date in maturity.

I hope this help in writing the formula. Thanks again for responding and for anyone else who can help.