Hi All,
I have atttached a sample of my spreadsheet.
What I need ti to do, is enter the next date from column A - in cell F6 - dependant on the value of column C.
So, if column C is uncompleted (No "X") I want F6 to show the first date matching the uncompleted cell - in this example A98.
Anyone have an idea on formula of macro to do this?
Bookmarks