We get these spreadsheets from a customer, they are stuck using week ending and will not change to the actual date.
What I am thinking to do is, or what I would like to do is, add a column, and then I would like to have it show me the actual date in that column that the entry is made.
If you see below, the snapshot of the spreadsheet.
Column D has the week ending date.
J,K,L,M,N,O,P are days.
There will only be one hour entry for each line, so if I were to add a column that would be column I.
I would like it to search the date where the hour is not equal to 0, and put the date in column I.
I'd need it to do this for each line.
Hopefully this makes sense, looking for ideas/suggestions/better ways/anything on how to go about doing.
Thank you!
What I am thinking to do is, or what I would like to do is, add a column, and then I would like to have it show me the actual date in that column that the entry is made.
If you see below, the snapshot of the spreadsheet.
Column D has the week ending date.
J,K,L,M,N,O,P are days.
There will only be one hour entry for each line, so if I were to add a column that would be column I.
I would like it to search the date where the hour is not equal to 0, and put the date in column I.
I'd need it to do this for each line.
Hopefully this makes sense, looking for ideas/suggestions/better ways/anything on how to go about doing.
Thank you!