Hello,
I wonder if anyone as any suggestion for a formula or function to get a result.
I have 3 date columns formated like dd-mm-yyyy hh:mm:ss with several rows.
Date of entry; Date of work first stage; Date of work done.
The result im looking is something like find if, when the work was done (third column), it existed any work on the first stage (second column) and older (first column). The result can be 0 and 1 so i can sum it up.
any suggestions. I tried vlookup but was lost along the way due to the giving conditions.
The idea is to find out if when certain work is done if it was done by skiping older works pending.
thanks.
Bookmarks