Hi,
My name is Puneet and I need your help to solve the following problem with Excel VBA code.
I need to automate the process of entering process date in excel sheet. Process date is calculated on the basis of following rules:
1. It is equal to effective date (say date entered in V column.
2. If effective date is in past month, then process date (in column Z) should be current date.
3. If something is processed after cut off date (say cut off date is 26 of every month), then process date should be 1st of next month.
Effective date is captured in mm-dd-yyyy format. Also column Z will be non-editable (freezed).
My name is Puneet and I need your help to solve the following problem with Excel VBA code.
I need to automate the process of entering process date in excel sheet. Process date is calculated on the basis of following rules:
1. It is equal to effective date (say date entered in V column.
2. If effective date is in past month, then process date (in column Z) should be current date.
3. If something is processed after cut off date (say cut off date is 26 of every month), then process date should be 1st of next month.
Effective date is captured in mm-dd-yyyy format. Also column Z will be non-editable (freezed).
