NARAYANK991
Excel Ninja
Hi ,
As far as the code and the CF are concerned , the date of interest is only the date in column AE ; the dates you enter in column G can be any dates , either in the past , present or the future. Any time a date is entered in column G , today's date is put in the corresponding cell in column AE , and it is this date which is checked each time you try to modify a cell in column G.
The dates in column G themselves are never used in checking.
Regarding your second point , the answer is No. The dates put in column AE are not through a formula but through the code , and once a date has been entered in a cell in column AE , the code will never again do anything to this cell. Thus , what ever happens in the rest of the workbook , the date which has been entered once in a cell in column AE will remain that date for ever , unless you clear that cell or put in a different date.
Narayan
As far as the code and the CF are concerned , the date of interest is only the date in column AE ; the dates you enter in column G can be any dates , either in the past , present or the future. Any time a date is entered in column G , today's date is put in the corresponding cell in column AE , and it is this date which is checked each time you try to modify a cell in column G.
The dates in column G themselves are never used in checking.
Regarding your second point , the answer is No. The dates put in column AE are not through a formula but through the code , and once a date has been entered in a cell in column AE , the code will never again do anything to this cell. Thus , what ever happens in the rest of the workbook , the date which has been entered once in a cell in column AE will remain that date for ever , unless you clear that cell or put in a different date.
Narayan