Pick up dates from column f which are greater than

[Closed]
Report
Posts
1
Registration date
Monday February 19, 2018
Status
Member
Last seen
February 19, 2018
-
 Blocked Profile -
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.

1 reply


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!