I need help. I have a report that I keep forgetting to change the week ending date. I need to tell the date cell to look in rows 8 through 75 and find the farthest column that has an amount, then grab the date from row 6 of that column and insert it in the date cell (J7).
Essentially, I have this spreadsheet that lists projects by row and every week, I update the expenditures over to the right (April 16 information was in column "AM"). Some projects will have expenditures, and some won't. But I need the date to show the most recent week ending date entered.
Can someone help me with this?
Essentially, I have this spreadsheet that lists projects by row and every week, I update the expenditures over to the right (April 16 information was in column "AM"). Some projects will have expenditures, and some won't. But I need the date to show the most recent week ending date entered.
Can someone help me with this?