Hi

I have a spreadsheet which shows a name in Column A.

The other columns are headed up with different dates in July.

Across the row, under the relevant date, appears the letter A or C or R.
This may appear several times across the row.

This shows which date that person will be able to perform a certain task.

On a separate sheet, I want to show the date of the night before, as that
person may need over-night accommodaiton in order to perform the task.

So, if Fred Smith is performing task R on July 4, 5 & 6, he may need
overnight accommodation on the nights of July 3, 4 & 5.

So Sheet 2 will need to look across that person's row on Sheet 1 for all
occurences of A, R or C; look up the date at the top of the column, then
return that date minus 1 however mnay times the A, C or R has appeared on
Sheet 1.

I hope this explains.

Can anyone offer a solution, please?