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. |
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. |
All times are GMT +1. The time now is 11:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com