I need to add it as a column in a date format so that I may calculate the
dates on the report

"MartinW" wrote:

Hi Martha,

I may be over simplifying here, but couldn't you just put
&[date] in the footer rather than part of your VBA routine.

Just a thought
Martin