View Single Post
  #1   Report Post  
Jade Summers Jade Summers is offline
Junior Member
 
Posts: 13
Default Autofilling dates

I am having a bit of an issue with being able to pull down my formula from E2 and it not make up a date if the D2 cell is empty. I know I need to put in some kind of a rule that will let the program know that I want it to remain blank if D2 does not have a date, but can't seem to find how. Here is my formula, any help would be greatly appriciated!

=DATE(YEAR(D2)+10,MONTH(D2),DAY(D2))