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.

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

VBA find column by name and sort
SidK -
bOFILL -

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

4 responses
Converting rows of data in notepad to columns
Need help -
Philgood_FR -

2 responses
How to copy the Column value into Rows
Raj_1562 -
TrowaD -

9 responses
Counting number of times a value appears if..
jensorr -
sambr22 -

7 responses