Help! We have a date in the format 01/01/2000 in column A1. We need to
produce a date in column B1 that is five years on minus one day (i.e.
31/12/2005). Does anyone know of a way to do this?

Many thanks!