How do I use the IF function with info that contains a date?

  • Thread starter Thread starter Red River Transport
  • Start date Start date
R

Red River Transport

I have a spreadsheet and would like to pull information from certain dates.
For example, our pay periods run from the first of the month through the
15th, and then again from the 16th through the end of the month. I'd like to
create an IF function that sums driver pay from the 1st through the 15th and
then from the 16th to the end of the month. Any ideas?
 
Hi,

If your data is by month then:

=SUMPRODUCT(--(DAY(A1:A31)<=15),B1:B31)

=SUMPRODUCT(--(DAY(A1:A31)>15),B1:B31)
 
Back
Top