Hi All,
Looking for formula or code that cell K4 will look at cell I4 and if their is a date in I4 do nothing, if I4 is blank look in cell E4 (which should have a date in it), then calculate the number of networkdays between cell E4 and the current date (today) the data is entered.
Their will be many rows with data and each row has multiple places where their could be blank cells. Cells in yellow are where I was planning to put the formula.
Not sure if code would be a better way to go about this.
See attached file.
A blank cell that should have a date in it means someone is working on a task but has not finished, when finished they will Initial and date it and move it on.
Trying to figure out how many days it has been sitting being worked on from a blank cell that should have a date, to the previous date in that same row.
Hope this is not too confusing.
Thanks for any help, Bikeman
Bookmarks