Thanks charlie

i have been thinking about it and i will just use a cheat method on
the print off page to give out the right answer e.g.
If column a2 says a certain date do this ,if that date do that i
think this will get around my date issue instead of getting it working 100% correctly through vba