Try Chip Pearson's Calendar:
http://cpearson.com/excel/download.htm
(look for Calendar)

Tim Hill wrote:

I have information on sheets with dates next to it. This indicates the last
time that a vehicle was mot'd. Is there anyway of these dates automatically
being placed into a calender??

I.e. the date is in a1 and for example the information (vehicle
registration) is next to it in a2. Ideally, i'd like a calender that can pick
up which wagon was mot'd and place its registration number into the calender
on the relevant date..

any help would be greatly appreciated

Cheers

--

Dave Peterson