Oh my goodness! BOTH of those work perfectly!!! Thank you both so much! I can't believe how much time I spent scouring forums yesterday and playing with different formulas trying to get something to work and now you have both responded within minutes with a perfect solution!!! thank you so so much!!

Just wondering, between the two formulas, is there one that may work better than the other? As I will be leaving after today, this spreadsheet needs to work smoothly for the other people in the office as they are not very excel-literate and will not be able to fix things if they go awry...