I am trying to populate AH5:AH17 in the "Sick Hours Used" with the month name (beginning of row) and the day of the month (column header) for any cell with an S, .75S, .5S or .2S no matter where they appear in B5:AF16.
ex: There is an .5s in cell W22 and I want to return Mar 22 in cell AH5
I then need to use cell W22 to enter the number of hours in AJ5 with S=8, .75S=6, .5S=4, .2S=2
This is what I would like the end result to look like
Appreciate any assistance!
ex: There is an .5s in cell W22 and I want to return Mar 22 in cell AH5
I then need to use cell W22 to enter the number of hours in AJ5 with S=8, .75S=6, .5S=4, .2S=2
This is what I would like the end result to look like
Appreciate any assistance!