Thank you both. Each work in the cells they were intended. Now is there a way to combine both formulas? The sample file is small but some will have upwards of 1500 records that I will need to do this for.