| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Compare date of a transaction against a range of dates
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. |
|
#2
|
|||
|
|||
|
One way
=IF(AND(C3=DATE(2005,8,10),C3<=DATE(2005,9,9)),E3 ,0) -- Regards, Peo Sjoblom (No private emails please) "D Campbell" <D wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
| adding occurrences for date range | Excel Discussion (Misc queries) | |||
| Change the low date range regional setting. | Excel Discussion (Misc queries) | |||
| SUMPRODUCT with date range question | Excel Discussion (Misc queries) | |||
| Is date within a range? | Excel Worksheet Functions | |||
Linear Mode
