Tharabai
09-12-2015, 02:34 PM
Hi,
I have three columns with dates
Column A - Periods
Column B - From Date
Column C - To Date
All I have to check is, for each value in column A, I have to check whether the from and to dates are within in that period.
For ex, I select the period as 15.08.15, for which I will check the "From Date" and "To Date". If the "To date" is blank we have to consider "From Date" else "To Date".
Step 1 - Fill all the blanks in "To Date" - the same value as the cell value in "From Date"
Step 2 - After filling check if the values in "To Date" are within the filter criteria. if not, filter the values that are greater than filter criteria
Step 3 - Fill those cell with the value same as "From Date"
Any code on this will be highly helpful and much appreciated.
As I have to check this for multiple periods any coding on this will be appreciated.
-Tharabai
I have three columns with dates
Column A - Periods
Column B - From Date
Column C - To Date
All I have to check is, for each value in column A, I have to check whether the from and to dates are within in that period.
For ex, I select the period as 15.08.15, for which I will check the "From Date" and "To Date". If the "To date" is blank we have to consider "From Date" else "To Date".
Step 1 - Fill all the blanks in "To Date" - the same value as the cell value in "From Date"
Step 2 - After filling check if the values in "To Date" are within the filter criteria. if not, filter the values that are greater than filter criteria
Step 3 - Fill those cell with the value same as "From Date"
Any code on this will be highly helpful and much appreciated.
As I have to check this for multiple periods any coding on this will be appreciated.
-Tharabai