Solved if statement to determine what falls between two dates and d

July 18, 2013 at 11:59:20
Specs: Windows 7
i'm needing to access two cells with dates in each and determine another cell to see if it is within those two dates and if so, display another specific cell.

See More: if statement to determine what falls between two dates and d

Report •


#1
July 18, 2013 at 13:09:22
✔ Best Answer
This formula will return Within! in D1 if the date in B1 is within the dates shown in A1:A2. It will return a blank cell otherwise.

       A           B          C              D   
1   4/5/2013    4/8/2013   Within!   =IF(AND(B1>=A1,B1<=A2),C1,"")
2   4/10/2013          

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
July 18, 2013 at 13:49:25
Works like a charm. Thanks for the speedy response. This 71 yr old can still learn with help like this.
Thanks again.

Report •
Related Solutions


Ask Question