Blank Date

I have a spreadsheet that looks for its data from sheet 1.
One of the columns is a date not all rows contain a date.
I formulate such that the data is copied to new sheet based on certain criteria

Please Login or Register  to view this content.

When I reference from this column it correctly puts the date in, but for cells where there is no date it shows 01/00/1900

I would like the cell to remain blank and not give me this 00/01/1900 date.

Also, I want to find number of months between two formulated cells(test date - discovered date) in this sheet 2. So, I took a new column and put this below formula

Please Login or Register  to view this content.

but, when I find difference between a blank cell in test date and discovered date I would like to see number of months between today and discovered date.

Thank you,

@FDibbins - Thank you for getting back to me. The 1st part seemed to work good, however the second formula for finding the difference works just like my formula. It is able to find number of months between test date and discovered date. This formula is still displaying #value error for cells which has blank test cell - discovered date. For such case I want to find difference between Today and discovered date.

Please look at the attached sample datasheet. In sheet 2 I am making modifications like updating data from sheet 1 for all 3rd party applications. There corresponding Status, Severity, Discovery date, Re-test date and formulate number of months and Cycle.

I want to find number of months between discovered date and re-test date for all closed applications and number of months between today and discovered date for all Open applications. Some Open status applications have re-test date but as they r not yet resolved I want to find months between today and discovered.

I am afraid I have confuse you. Please let me know if my words dint mean anything to you.

Thank you,

-Sai

I appreciate your help Sir!! and Well, That should be a major problem because I am taking first 9 months as 1 cycle. My other concern is you see the blank cells below row 26. I dragged the formula downwards and this gives #Num! error. Any suggestion on that??

@FDibbins - As I mentioned earlier, I have a specific task in calculating the number of months between Re-test date and Discovered date. If status is "Closed" in Column B then perform operation on Re-test date - Discovered date, but if status is "Open" then the number of months should be Today - discovery date.

I know this might be a troublesome way to arrange, but can you suggest something.

Thanks again.