massage popup show date difference as day month and year

Hi,

I google it but not getting a result for my worksheet.

Two Columns of the datasheet having date value difference pop as massage show as day month and year

Example:

C8:C100 and D8:D100 Both have date values.

On Entry of the "C" column, nothing happens if the "D" column is Blank.

When a date is entered in the "D" column, A massage will Popup showing the difference Like "2 months & 13 days"

Hope someone helps me.

Thanks in advance.

It Can be done by a formula but I can not change my worksheet by column

so, I think the only way to get the result is a popup message.

Any other suggestion will be much helpful.

Thanks.

Thanks, gijsmo

That is very helpful.

Much appreciate.