c16

Hi- I built an excel calculator that will determine the numberof total work days between two dates. The tricky part I have is I need to avoid all weekends. I have a start date in C16, and the problem Iam having is, if that date in C16 is a weekend of a holiday, (I have an arrayin L16:L28 for...

I have cell J11 with a drop down list which are 1,2,3,4. I need that: 1. When I choose 1, in cell c16 appears cell 'Tank 1'!E9 2. When I choose 2, in cell c16 appears cell 'Tank 2'!E9 3. When I choose 3, in cell c16 appears cell 'Tank 3'!E9 4. When I choose 4, in cell c16 appears cell 'Tank...

I have cell J11 with a drop down list which are 1,2,3,4. I need that: 1. When I choose 1, in cell c16 appears cell 'Tank 1'!E9 2. When I choose 2, in cell c16 appears cell 'Tank 2'!E9 3. When I choose 3, in cell c16 appears cell 'Tank 3'!E9 4. When I choose 4, in cell c16 appears cell 'Tank...

Excel 2007. Same workgroup with data in different worksheets. I require a formula in Sheet2: to say "YES" if Sheet1 B21, Sheet2 C16 and sheet3 B15 tally. If all 3 cells do not tally say "NO".

I swear I've done this before, but it's not working today and I cannot figure out why. In the table below, I have assigned the name "Header" to row 6 and "Footer" to row 12. In C12, I calculate the average of the ratings in C7:C11. In C13, I try to do the same thing, but using the named...

I have a text string (an individual's name ... surname, given) in B16 eg. "Martin, Allan" I am looking for a VBA solution to extract the individual's initials to be put in cell C16. In this example ... C16 = "AM" I know how to get the "M", but I am not sure how to isolate the first letter...