## Tuesday, November 26, 2013

### yogi_Extract Deposit No1 Deposit No2 And Deposit No3 (if applicable) For The Month And Year Of Specified Date

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 24, 2013
Finding the nth cell with a date in a certain month
Hi.  I'm working on a budget spreadsheet.  I get paid every 2 weeks.  I've come up with a listing of all of the days in the next year that I should expect to be paid.  Here's the first bit of it:

 Month Date of deposit Amount of deposit 11 11/15/2013 \$1,000,000,000.00 11 11/29/2013 \$1,000,000,000.00 12 12/13/2013 \$1,000,000,000.00 12 12/27/2013 \$1,000,000,000.00 1 1/10/2014 \$1,000,000,000.00 1 1/24/2014 \$1,000,000,000.00 2 2/7/2014 \$1,000,000,000.00 2 2/21/2014 \$1,000,000,000.00 3 3/7/2014 \$1,000,000,000.00 3 3/21/2014 \$1,000,000,000.00 4 4/4/2014 \$1,000,000,000.00

As you can see, we're pinching our pennies. :-)  Now, on another sheet, I'd like to set up three cells.  The first one is the date of the first deposit in a month.  The second is the date of the second deposit.  The third is the date of the (infrequent) third deposit of the month.  Like this:

 Current Month: 12/1/2013 Carryover First Deposit of Month 12/13/2013 Second Deposit of Month 12/27/2013 Third Deposit of Month N/A

I'd like the dates in the right column to autofill from the listing of paydates above.  I'm really coming up with a blank on how to do that, though.  It seems like it would be something like, "find the first entry with a month and year matching the month and year in the current month" and then again for the second entry and the third.  But how?  Any suggestions on an approach to this?  Many thanks in advance.
---
hanks for the reply.  The sheet can be seen at:

I've added notes to the cells that, I hope, explain what I'd like in each cell.  Thanks again for taking the time.
-----------------------------------------------------------------------------------------------------------------------------