ExcelBanter - Autofilling dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Autofilling dates (https://www.excelbanter.com/excel-discussion-misc-queries/446447-autofilling-dates.html)

Jade Summers

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))

Spencer101

Quote:

Originally Posted by Jade Summers (Post 1603214)

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

Jade Summers

Quote:

Originally Posted by Spencer101 (Post 1603216)

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

Thank you, wonrked like a charm!

Spencer101

Quote:

Originally Posted by Jade Summers (Post 1603490)

Thank you, wonrked like a charm!

Glad to be able to help, Jade :)

All times are GMT +1. The time now is 11:59 AM.