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

  • Thread starter Red River Transport
  • 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?
 
S

Shane Devenshire

Hi,

If your data is by month then:

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Divide month into two payroll periods 5
Help needed with a formula for dates in excel 2007 2
Date Range for my time sheet 2
function to fill all days of month to end of month 11
Leap Year 2
How do I add value to a cell based on the calendar? 1
Auto calculating the month end 8
Custom date ranges for report groups 1

Top