I've searched the board and found solutions to similar issues, but nothing that addresses the problem I'm working on. I'm using Excel 2010.
Column H contains an opening date. Column I contains ages calculated via formula (e.g., I4 contains "=TODAY()-H3"). Column J may or may not contain a date. If Column J contains a date, Column L should display a closure age calculated by subtracting the date in Column H from the date in Column J.
I need a macro that generates the following results, and I'm coming up dry:
If the cell Column J is empty, the cell in Column I should display an age and the cell column L should be empty. If a date is entered into the cell in Column J, the cell in Column I should be empty and the cell in Column L should display a closure age. I need this to apply to all cells in these columns between Row 3 and Row Infinity.
Thank you for your assistance; this is my first dive into VBA and macros.
Bookmarks