Excel Formula on 30 Days and 60 Days

Microsoft Excel 2007
January 29, 2010 at 16:53:30
Specs: Macintosh
I am trying to figure out out to set up the formula. I
have sales team who are paid by commission.

First 30 days, they get commission based on the
activation after sold date. Also, they get 2nd
commission from 31st to 60 days if the device shows
activation. If after 60 days, they are not eligible for
commission at any point.

See More: Excel Formula on 30 Days and 60 Days

January 29, 2010 at 18:48:32
We're glad to hear that you are trying to set up a formula.

If you need any help, feel free to ask. ;-)

Report •

January 30, 2010 at 04:53:53

From your post, it looks like you want a formula that returns a higher rate of commission if activation occurs within 30 days of the sold date, a lower rate if activation is between 31 and 60 days and no commission if the interval is longer.

If that is what you are looking for, then try this
Place Sold date in cell A6
Place Activated date in cell B6
and in C6 place this formula:


As you didn't say what the commissions are, I just used 10%, 5% 0%

To protect against an erroneous result when one or other date is empty add a test for empty cells, and the formula becomes:

=IF(OR(A6="", B6=""),"",IF(B6-A6<31,10%,IF(B6-A6<61,5%,0%)))


Report •

February 1, 2010 at 11:47:26
there won't be any % on commission. It is going to be a flat

$25 for first 30 days and $35 for between 31-60 days.

Report •

Related Solutions

February 1, 2010 at 14:10:14

You can just replace the percentages in the formula with your values.

10% becomes 25, 5% becomes 35 and 0% becomes 0, and Format the cell with a currency format.

On re-reading your post, I am not clear - are there three dates or just two -
Can staff get both $25 & $35 commission, or is it one or the other.


Report •

Ask Question