reference cell should be blank not 00-jan-00 how make it read like the blank cell (Blank )

Try changing the formula in sheet 2:

=IF(date2="","",date2)

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

If you have a cell that is reading 00-jan-00, that tells me that you have that cell formatted as a date, but the contents are 0 (zero). Try changing the format to General?