I'm getting an error and that could be because in Column F it is not a normal Date value. Listed above I showed the formula that I have in there to pull a certain date for me. So with the code that I have thats working mostly I'm just trying to figure out how to make it read that cell correctly instead of looking for a date value.