I have a data table tracking the number of hours for a specific project. Row one is headers for columns A and B and dates for columns C:DY. The projects are in column "A" and the total estimated hours in column "B". I then am taking the total estimated number of hours and am dividing them up in columns c:dy. Say I have a job XYZ that is estimated to take 10 hours, columns C & D will have a 5 in them each, meaning that project will be worked on for two different days at 5 hours a piece, no other columns will have data in them for that project.
I need to return the date that will be in the first blank column, in this case, column "E".
This is being built to help manage different project and show when the estimated end date will be.
How might I be able to do this?
Please help me, thank you!
I need to return the date that will be in the first blank column, in this case, column "E".
This is being built to help manage different project and show when the estimated end date will be.
How might I be able to do this?
Please help me, thank you!
Last edited by a moderator:
