Hello everyone
I want to find and have it in one cell the periods that a person used sick leave (for record purpose) in the month (see example below). I've tried to find something online, but haven't succeed.
By the way, still using excel 2010 .
For example:
A1 to AE1 are dates from Jan 1 to Jan 31
Cells D2, E2, F2, N2, O2, P2, Q2, W2, X2, Y2 and Z2 has letter S, which indicates the day person was on sick leave.
I need in cell AF2 to have the following
Jan 4-Jan 6, Jan 14-Jan17, Jan 23-Jan 26.
Thanks a lot.
I want to find and have it in one cell the periods that a person used sick leave (for record purpose) in the month (see example below). I've tried to find something online, but haven't succeed.
By the way, still using excel 2010 .
For example:
A1 to AE1 are dates from Jan 1 to Jan 31
Cells D2, E2, F2, N2, O2, P2, Q2, W2, X2, Y2 and Z2 has letter S, which indicates the day person was on sick leave.
I need in cell AF2 to have the following
Jan 4-Jan 6, Jan 14-Jan17, Jan 23-Jan 26.
Thanks a lot.