Applying a formula only to the first date in a month

[HRCoord]

I have a row of pay dates, B7-B36, each two weeks apart, e.g. 5/4/12, 5/18/12, 6/1/12, etc. I also have a row of values (E7-E36) that I want to pull from another cell (B3), but I only want the value to show up on the first pay period of each month. What formula can I use so that the calculated number only shows up if it's the first pay period of the month, and otherwise shows "0"?

Thanks!

Terrell

[Roger Govier]

Hi

In C8
=IF(MONTH(B8)=MONTH(B7),"",(D8*80)+SUM(E8:H8))

and copy down

[Ace_XL]

Array formula

=IF(A7=MIN(IF((MONTH($A$7:$A$36)=MONTH(A7))*(YEAR($A$7:$A$36)=YEAR(A7)),$A$7:$A$36)),$B$2*80,"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[ConneXionLost]

In cell E8 try:

=IF(MONTH(B8)=MONTH(B7),0,$B$2*80)

autofill down.