JLatham wrote:
Because you're using the OFFSET() to get the date into that merged cell at
K15:... it doesn't pick up the formatting from the source cell in column B.
Fix should be easy, just click in the merged cell there at K and format it as
a date separately.


Wanna hear something funny..... for some reason, I woke up last night
and that popped into my mind. I went in and turned on the computer.....
brought up the sheet... sure enough, I hadn't formated the K cell for
date.

.....how embarrassing is that? ----haha!

Thanks again
Johnnie