| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use the IF function with info that contains a date?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use the IF function with info that contains a date?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recovering File Info Specifically Save Date or Print Date | Excel Discussion (Misc queries) | |||
| Comparing two columns containing Date info | Excel Worksheet Functions | |||
| Syntax for Info or Cell function for xl. file creation date | Excel Worksheet Functions | |||
| Return info based on Date Range | Excel Worksheet Functions | |||
| Calendar and info for that date | Excel Discussion (Misc queries) | |||
Hybrid Mode
