Date formula with ISBLANK or IF condition from previous column entry

[Screwtape]

Please help a lost new user, many thanks!

I am trying to have any dates entered in column J result in a date 3 years later in column K, and where a cell in column J is left blank, result in a blank cell in column K, rather than 1901-00-00, or a Value! error message. Also, cells available for such entry begin at row 3 in both columns, as there are text headers in rows 1 and 2.

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

Please update your user profile with the version of Office (Excel) that you are using, NOT Windows.

[Fluff13]

Hi & welcome to the board.
How about in K3 copied down
=IF(J3="","",edate(j3,36))

[maclearyj]

Hi there. Put this formula in K3 and drag down as necessary:

Please Login or Register  to view this content.

[Screwtape]

Thank you, I am pressed for time, I will modify my profile and only post with sample workbooks in future. Thanks for welcome and help!

[Screwtape]

This worked, thank you kindly for your assistance!

[Screwtape]

Thank you!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[Fluff13]

You're welcome & thanks for the feedback