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

's Computer Specifications

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 Computer Specifications

Hi,

If your data is by month then:

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

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Red River Transport" wrote:

> 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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Recovering File Info Specifically Save Date or Print Date	Gadgetgw	Microsoft Excel Misc	4	6th Oct 2008 08:43 PM
Syntax for Info or Cell function for xl. file creation date	=?Utf-8?B?ZHJpbGxlcg==?=	Microsoft Excel Worksheet Functions	5	29th Jan 2007 07:51 PM
Calculating days between current date and a date in future NETWORKDAYS() function	Faheem Khan	Microsoft Excel Worksheet Functions	2	10th Feb 2005 07:18 PM
Datedif function doesn't work when I use the cell with a date as start date reference	Joy	Microsoft Excel Worksheet Functions	2	3rd Apr 2004 12:47 AM
Need to automatically update date in a date field when record info changes	Stacey	Microsoft Access	1	30th Oct 2003 07:04 PM