jackfox68
Board Regular
- Joined
- Jan 24, 2010
- Messages
- 121
Hi Everyone,
I am trying to write a formula that will return a value of either true or false if a cell contains a date that is equal too or greater than a starting dates, and equal to or less than an ending date. So for example starting date in cell A1 is 10/1/2014 and end date in cell A2 is 10/31/2014. The date to evaluate in cell A3 is 10/2/2014. The formula I attempted to use was with the AND function and went as follows:
'=AND(A3>=A1,A3<=A2)
For some reason this always returns a false argument.
Any help would be appreciated.
I am trying to write a formula that will return a value of either true or false if a cell contains a date that is equal too or greater than a starting dates, and equal to or less than an ending date. So for example starting date in cell A1 is 10/1/2014 and end date in cell A2 is 10/31/2014. The date to evaluate in cell A3 is 10/2/2014. The formula I attempted to use was with the AND function and went as follows:
'=AND(A3>=A1,A3<=A2)
For some reason this always returns a false argument.
Any help would be appreciated.