Hello Everyone
I am new to the forum and occasionally work on Excel to automate few of day to day work. I find this forum very rich in content and have solved lot of my problems in the past.
So to start with, I will like to thank the members of this forum who are out there to help people like us.
Now to explain my situation:
1) I am in process of creating a meeting template for my team. We support a pretty huge Unix mid range environment.
2) This meeting template is like a record keeper for managers to understand the biggest concern areas / issues in the support environment.
3) I have a column, "Report Date" (Column D) and I have a column, "Aging" (Column H). Report date is self explaining, the day the issue was reported, it's a manual entry column. I have created one column (Column V), which is hidden in template to rest of the people, that has got the cell value as "=IF(B8="Open", TODAY())"
4) The column B is a column with value, "Open" & "Close". So until the issue is in "Open" state, the hidden column will be true and will keep showing the current date
5) The "Aging" column then have got this value "V4-D4" and driving it's value for the number of days the issue is open. So far, so good. Now find below my challenge
Challenge I am facing:
1) I want to add a new column as, "Date Completed"
2) I want to automate the process of this value in "Date Completed" to be done automatically
3) So the moment I mark, "Close" in Column B, the "Date Completed" cell in the row gets populated as per the current date and is freeze
I hope I have been able to explain my problem. The reason I am doing this is that I want to see how much time we take as a team to resolve and address issues.
Thanks all again for the past assistance I have received from this forum and thanks in anticipation for this challenge.
Thanks & Regards
Amit
Bookmarks