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
Creating a Search using a combo box and then creating a report. 4
Help needed with a formula for dates in excel 2007 2
Problem with SET & REF function 0
If or VLookup function 0
Pay day 14
First Half / Second Half Month Budget 3
New computer, how do i move outlook 365 ENTIRELY? 0

Top