Counting Days until Cell contains value

I am looking to have the columns labeled "Days until Safety Complete" and "Days until Detail Complete" to count the days from the "Date" column until the "Safety" or "Detail" column contain anything (or no longer blank).... Anyone know how to do this?

Can email file.... Would not let me attach for some reason

should be attached now

Originally Posted by JohnTopley

I understand correctly, you want to "record" the date the "Safety" or "Detail" column was completed i.e. something entered in either of these columns, and subtract the data in column A.

So if H2 was entered on 14th November, J2 will contain 3 (14th - 11th)

To this will require VBA (Worksheet Event)

Yes that is exactly what I am looking for. We are wanting to be able to measure the time it takes for them to be completed and the Column H indicates it being completed by entering the technicians initials

Please Login or Register  to view this content.

Right click on "Safety Details" tab==> view code ==> copy/paste code.

Data entered in H or I will add elapsed days in J and K