Previous Topic Next Topic

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

Answer 1 / 1
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!
0

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
blank white page for website
yadaves -
ac3mark -

1 response
IF statements with dates and criteria
jimbabama -
Mazzaropi -

3 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
using web browser page loads but screen blank
inchoate -
leo -

16 responses