How do I count cells from right then stop count when criteria chan

[tjaviation]

II am trying to use a formula to count cells in a row containing the letter D
starting the count from the right or end of the row then stopping the count
when a cell contains a different letter. This is for determining what
employee has been on day shift the most in continuous months. Such as
MMADADDDDDDD. I only want to count the D's from the right until I get to A,
to get an answer of 7 not 8.

 

[JoAnn Paules]

I would suggest posting your question in an Excel newsgroup, rather than a
miscellaneous Office one.