i have i column contain some data between this data a date found like:
Shifts per day 13/04/2014
that i want to extract this date in another column to insert pivot and countif "DO" in each date
sorry for non clarifying,
according to your formula i face an error #VALUE!,
after extracting it in the range for (B: P) is founded word of "DO" that i want to count
say after extracting the date i have 5 days from 15/4/2014:20/4/2014 i ask to count "DO" in each day
i want to extract the date from column B to column A
and after extracting i want to make a pivot with the date to count "DO"
the simple file attached in the first post
I don't know why you are facing problem with Deb formula. See the attached pic below extracted dat based on Deb formula and as explained in Comment #6.