Compare all column date vs date in each row and Clear cell if not within 12 months

  • Dear all,


    I'm trying to figure how to clear individual cell in each column based on the Contract date per row.


    Compare all column date vs date in each row and Clear cell if date not within 12 months.


    I attached the print screen example of the output it should show.
    Those highlighted in pink are the cell i want to remove.
    Those not highlighted are the existing values to keep. There's some formula in the cell so not all the cell are values.


    Column will repeat itself from year 2017 to 2020 in YYYYMM order
    201701 represents the Jan 2017
    All 12 months from date of Contract Month -- I want to keep these columns.


    Example 1. Contract Month = 1 Jan 17, so the cell to clear is those column from 201812 onwards.
    Example 2. Contract Month = 1 Jan 18, so the cell to clear is those column from 201701 to 201712 and 201901 onwards.


    [ATTACH=JSON]{"data-align":"none","data-size":"custom","height":"62","title":"pic1.jpg","width":"1052","data-attachmentid":1219277}[/ATTACH]
    [ATTACH=JSON]{"data-align":"none","data-size":"custom","height":"59","title":"pic2.jpg","width":"1052","data-attachmentid":1219278}[/ATTACH]



    Any help appreciated!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!