Anybody quickly give me help with excel?

[Supertree]

I'm creating a spreadsheet and want to have it automatically fill in a date of expiry which is a year on from the start date. I have a formula in place to do this, but I want the formula to be ready in that column for any new date which is entered, as new data will be entered on a regular basis. I've copied the formula down the entire column, but the empty rows awaiting new data now have a random date in the expiry column, which will presumably change to the correct date once a start date is entered, but looks very confusing now. How can I change it so that the cells have the formula preprogrammed but look empty until the row is filled in?

Are the cells to the left of the formula empty?

Use an if statement to say IF cell is blank THEN show blank, ELSE show results of formula, for eg if the cell that may or may not have the date in is A2 then put this formula into the cell you want to show A2 + 1 year:
=IF(A2="","",DATE(YEAR(A2)+1,MONTH(A2),DAY(A2)))

That's how I'd do it anyway!

Yes I agree with @Aubasaurus it's an IF statement you need.

You should be able to add an IF formula Infront of your existing formula to add the date, something like =IF(ISBLANK(A1), 0, YOUR EXISTING FORMULA) (imagining the date you are adding a year to is in cell A1) if A1 is blank it would input 0, otherwise it would show the result of the formula. Something like that.

That's brilliant, thanks :) I now have another question... How do I get it to fill all the way down? I don't want it to be in the header or title rows, so how can I copy that formula all the way down to the bottom from a specific cell instead of the whole column?

I've figured it out now. Really out of my comfort zone here.