Autofilling dates

J

Jade Summers

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

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

Spencer101

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

=DATE(YEAR(D2)+10,MONTH(D2),DAY(D2))
Click to expand...

Try putting IF(D2="","", before "date" in your formula and anothe
closing bracket at the end of the formula.
 
J

Jade Summers

Spencer101;1603216 said:
Try putting IF(D2="","", before "date" in your formula and anothe
closing bracket at the end of the formula.r
Click to expand...

Thank you, wonrked like a charm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates and if statements 3
Need help with an IF Function 4
Comparing two columns with conditional formatting 4
sumifs function 3
Creating a Search using a combo box and then creating a report. 4
Comparing Dates 4
How to pull in data from rows and columns if there are blanks? 0
Formatting a spreadsheet to calculate difference in dates etc. 2

Top