Ok folks, thanks for the replies. Just to clarify, i have a template, with both dates in relevant places multiple times. We have 21 rooms, but very often, most of the rooms will be occupied by the same people.

I have two folders, one for current service users, and another folder for to keep records for service users who have used the services in the past.

When a new resident comes in, I will open the template, fill their details in, national insurance etc and reason for homelessness, then drop it into the folder with the current users.

All the files can be selected and sent to the printer at once and if i get the dates going, it will save having opening up each file every day.

we work with a lot of drug and alcohol users and any time I can save at a computer helps us focus on more important things so that's why I' looking to steam line the process.

Here is a section where i have to do both dates, there are 4 other sections where I have to do this, multiply this by 21 and you can begin to see why I'm trying to solve this.

The current date is simple enough, but tomorrows date in red is where I need to get help.

Anyway, ill look into your kind replies and get back to let you know how I get on.

Attached Images

example.gif (64.1 KB, 31 views)