Date formula to not display result

[GPetcu]

Hello everyone

I have a sheet that I am using to calculate due date. I have a column with date of induction and another column that calculates the date based on the value in the column next (I have attached a picture of the columns for your visibility). As I have copied the formula down to calculate future date that I will input, the cells have populate with 31/12/1900 as there is no date to calculate the result from.

Is there any way to stop excel from displaying a date if there is nothing to calculate it from? In other words I would like to get rid of the 31/12/1900 and display a result if there is a date in column E (Date of Induction).


Thank you for your time.

Regards,
Gabriel

[shukla.ankur281190]

May be something

Please Login or Register  to view this content.

[davsth]

Please Login or Register  to view this content.

[GPetcu]

Hello

Thank you for taking the time to come back to me. This is exactly what I was after.

Many thanks,
Gabriel

[shukla.ankur281190]

Glad it helps you
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks. If you liked any solution please add reputation by clicking star icon left corner of your screen.