If function with range of cells

Hey sanlen,

Not sure what you mean by "partially is date" can you give an example record for the first two cases (DONE, IN PROGRESS) ?

- melk

hi sanlen ,

upload sample workbook with out any confidential data & make sure it is having enough data to explain your problem

Punnam

Hi,

I have attached the sample of my worksheet.

Your further comments will be very much appreciated.

Regards,
sanlen

Hi sanlen ,
every thing is fine but you have to use Ctrl+Shift+Enter instead of normal enter , as the function is array function
try the above combination than it is working fine

Punnam

Hi Punnam,

Thank you very much for your great support. It is working now

Regards,
sanlen

hi sanlen,

Thanks for the feedback, mark the thread solved , using the thread tools you can also thank one who helped by using the "ADD REPUTATION" TAB on left corner of all my posts .

Punnam