Compare date of a transaction against a range of dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The formula I'm using is "=if(datevalue("08/10/2005")
<=$c3<=datevalue("09/09/2005"),$E3,0)". I have a transaction date of
09/05/2005 in cell c3 and a transaction amount of $3,500 in cell e3. My
formula is not returning a value of $3,500. The logical test from the
formula is returning false. There are no other add-in tools to include in
the Excel start up.
 
One way

=IF(AND(C3>=DATE(2005,8,10),C3<=DATE(2005,9,9)),E3,0)

--
Regards,

Peo Sjoblom

(No private emails please)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question: How many occurences in date range? 4
Combine results of 2 formulas 2
Conditional sum equals 0 4
Sum multiple worksheet sales data by month 4
2 dimensional date sort 1
Date/Time 1
Find LAST date when corresponing min value became available 7
I need a formula to add numbers to the result in same cell. 1

Back
Top