this is great. however i can we do some formatting on d(1,1) as yyyymmdd? i can put this in this in the excel but will need a separate cell to convert. I really appreciate your help. its perfect.