Display start and end of tasks
Hello,
If anyone can help, I have a table of tasks and a row showing days, and below that row are rows with the completion of tasks, which is marked with an “x”. How to display information in column “B” with start day and in column “C” with end day for the given task.
As an example, I am attaching a photo in which the columns in which I want to extract the information with formulas are marked in yellow, and I have given the manually entered data for the first two tasks as an example.
Thanks!
Hello,If anyone can help, I have a table of tasks and a row showing days, and below that row are rows with the completion of tasks, which is marked with an “x”. How to display information in column “B” with start day and in column “C” with end day for the given task.As an example, I am attaching a photo in which the columns in which I want to extract the information with formulas are marked in yellow, and I have given the manually entered data for the first two tasks as an example.Thanks! Read More