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!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!