Pick up dates from column f which are greater than

Closed
Ashar29 Posts 1 Registration date Monday February 19, 2018 Status Member Last seen February 19, 2018 - Updated on Feb 20, 2018 at 05:50 AM
 Blocked Profile - 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.
Related:

1 response

Blocked Profile
Feb 20, 2018 at 05:01 PM
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!