Hi,

I have created a spreadsheet but, have encountered a problem with the formula or maybe the format, not to sure.

I have a workbook containing 5 worksheets. The first sheet is my 'results' page and the other four contain data, set-up like a database. I'm using the vlookup formula to populate my cells (column) in my first sheet.

Column c of sheet 1 looks up the data and populates that column, column d is for a refresher date and has the following formula - =IF(ISTEXT(C2),"",IF(C2<0,DATE(YEAR(C2)+1,MONTH(C 2),DAY(C2)),""))

If data is found and column c is populated with a date then column d creates a date one year on, which works ok. But when I copied the formula into column d only some of the cells with dates produced a future date. The only way I can get it to display a date in column d is to go into the database and re-type the date, when I switch back to me results page column d is populated.

Thank you.