On Feb 18, 11:05*am, Sheeloo <Click on my name above to get
instructions for getting my email id wrote:
Excel stores dates and times as a number representing the number of days
since 1900-Jan-0, plus a fractional portion of a 24 hour day: * ddddd.tttttt
[seehttp://www.cpearson.com/excel/datetime.htm#SerialDatesfor details]

Today's date is stored as 39862

As a result any cell containing a number will pass the test of containing a
date. If you know the possible date range then you can test for the numbers
in that range..
What if I needed it to look at the date in two columns and add the
value in the next cell for each one that is true?
Basically V4 =If F4 or H435000, then SUM(B4+G4+I4), then subtract the
value in cell U4 from that sum, but IF F4 and H4 <35000, then value in
V4 =B4-U4.

I made one that looks at just one of the date columns and add the $
amount
=(IF(AND(ISNUMBER(F4),F435000),G4+B4,"")-U4)

I want it to add the $ amount from two columns if both are true,
either one if only one is true, and neither if both are false.

B4 = Previous Balance
F4 & H4 = Date
G4 & I4 = $ Amount
U4 = Withdraw
V4 = New Total


You can do something like
=IF(AND(A139000,A1<40000),B1+C1,"")

"chocoearl" wrote:
How do I make an If-Then formula to add the value of two cells only if
another cell contains a date entry?

Earl