Pick up dates from column f which are greater than

Ashar29 1 Posts Monday February 19, 2018Registration date February 19, 2018 Last seen - Feb 19, 2018 at 11:42 PM - Latest reply: ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen
- Feb 20, 2018 at 05:01 PM
Hello,

I need help with a vba code logical statement
I have a worksheet1 where c19 is start date and d19 is end date.
There is another sheet whose column f contains a series of dates.
I need to pick up dates from column f which are greater than equal to start date and less than equal to end date and then copy paste the dates in worksheet1 say range c25.

Pls help.
See more 

Your reply

1 reply

ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen - Feb 20, 2018 at 05:01 PM
0
Thank you
You can combine both IF and AND.

You start with the AND first, as in:
=AND(if(a1>b1), if(b1>c1))

This says, return true if both A1 is greater than B1, and B1 is greater than C1.

It is that simple!
Respond to ac3mark