P2: = DATE(YEAR(E2)+3,MONTH(E2),DAY(E2))

Not sure what you are asking for the second part. I get the drift but not
the detail.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Eva" wrote in message
...
I have a spreadsheet for training dates and need to be able to create
formating on a couple of the columns, the 4th colom (E),contains dates
ddmmyyyy from these dates I need to be able in another column (P)
highlight
that the refresher course needs to be done in 3 years time e.i 22/12/2006
refresher course 22/12/2009 can I also put in a generic timescale of 1095
days as this will always be the timescale involved rather than individual
dates as I have thousands of rows, also can I set a condition in another
colum of 1035 days and sent this to an AMBER stage so we know that the
course
will need to be re-booked, what formula do I need in each instance ??

Version-Excel 2003
Many Thanks
--
Eva