[Fred]

Hi Doug,

Thanks for the reply, I've successfully used DateDiff(), however that
leaves me with the problem of the +/- display.

I am required to show positive numbers prefixed with + and negative
prefixed with -. It seems that the default is no prefix for positive
and - for negative, I have tried the format of +#,##0, but, for a
negative difference I get "+-14" and a positive difference gives "+28",
so i'm part way there.

Thanks for the IsDate, i'll try that next.

Regards
Fred