Insert a value based on a date range from other cells

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
I want to make a payment represented in A3 if the date falls within any two week period

What date are you referring to?
 

octavio

New Member
Joined
Oct 13, 2006
Messages
2
in this particular example it is the 22nd of each month which is is cell b3. I just want to automate the process by having the payment inserted in the right cell based on the date.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,268
Office Version
  1. 365
Platform
  1. Windows
octavio

See if this is headed in the right direction. Note that my dates are in Australian format (dd/mm/yyyy)

Formula in C3 (copied across and down):
Code:
=IF(AND(DAY(C$1)<=$B3,OR(DAY(C$1+14)>$B3,MONTH(C$1)<>MONTH(C$1+14))),$A3,"")

Is it possible that you could have data where the payment day is below 14 (like row 6 in my example)? If, so what results would you expect for row 6?
Mr Excel.xls
ABCDEFGHIJ
1PaymentPayment By This12/01/200726/01/200709/02/200723/02/200709/03/200723/03/200706/04/200720/04/2007
2AmountDay Each Month
310022100 100 100  100
415015150 150 150 150 
520027 200 200 200 200
62503        
7
Payments
 

Watch MrExcel Video

Forum statistics

Threads
1,109,204
Messages
5,527,396
Members
409,759
Latest member
KCH

This Week's Hot Topics

Top