Dear Friends,
I have two dates (UN-SEP-2006 and 28-Jun-17) where the first date day value is UN (Unknown). In this case, How do I find the difference between these two dates? Please suggest.
Dear Friends,
I have two dates (UN-SEP-2006 and 28-Jun-17) where the first date day value is UN (Unknown). In this case, How do I find the difference between these two dates? Please suggest.
You have to first supply a value for UN.
Otherwise, you will never know the difference because you don't know the day for the first value.
I would suggest using a text editing function to replace UN with a placeholder value, such as 1 and just default the dates with UN to the first of the month.
With the UN date in cell A1, use a function like this:
="1-"&RIGHT(A1,LEN(A1)-FIND("-",A1))
Then select that cell and hit: Ctrl+C, Alt+E+S+V Enter. Then you can convert the cell into a proper Excel format one of many ways, the easiest of which is to double-click the cell and hit Enter.
Now, use regular date functions for the two dates.