Need your help to calculate the differences with a formula

Hi All,

I would like to calculate the difference between Highest and lowest date of the table for each row. Would it be possible to calculate the same in single formula???

I have attached the file for your reference

Thanks & Regards,
Nitin

Hello Nitin
As long as the blank cells are blank and don't contain zeros, this should work:

Formula:

Please Login or Register  to view this content.

Copied down the column and formatted to General or Number.

DBY