I'm at a loss with the Day() function. Write the formulas for columns D, E, F and G to display the Invoice Amount Due for each invoice in the column corresponding to the Invoice Due Date. Consider only the DAY portion of the date (using the DAY() function that returns only the DAY portion of the date) and place the invoice amount in the columns based upon the following business rules: Week 1 Payables are Due on the 1st thru the 7th day Week 2 Payables are due on the 8th thru the 14th day Week 3 Payables are Due on the 15th thru the 21st day Week 4 Payables are due after the 21st through the end of the month For example The Invoice in row 6, due on the 1st day of the month, would display $8,612.00 in cell D6, the invoice in row 7, due on the 29th day of the month, would display $2,750.00 is cell G7, and so on. Could someone please explain how to start the formula for Week and 3? I have answered Week 1 and 4. Here is what I answered for week 1: =IF(DAY(InvDate)<8,AmtDue,"") Here is what I have for week 4: '=IF(DAY(InvDate)>22,AmtDue,"") I have attempted week three, but it is wrong. Here is what I have so far: =IF(DAY(InvDate)>=8,AND(DAY(InvDate)<15,AmtDue,"")) Please help.