I have a huge worksheet with some cells containing the date in the format mm/dd/yy and some cells with only only the date entered.
Cell A1 contains 10/03/2011
Cell B1 contains 7
Cell C1 10/06/2011
Is there a formula that would allow me to only copy cells with the format mm/dd/yy, ignoring the other cells?
Cell A1 contains 10/03/2011
Cell B1 contains 7
Cell C1 10/06/2011
Is there a formula that would allow me to only copy cells with the format mm/dd/yy, ignoring the other cells?
