Forum Discussion
Solved
Problems with Excel 365 sheet, COUNTIFS formula...see attached sheet with narrative about my issue
I would need to attach a sample sheet in order to adequately explain the issue at hand. I don't see a paperclip here. Let's start out by giving me instructions on how to attach an Excel sheet please....
If D7 contains a formula such as =C7 and is formatted as dddd, column D still contains dates, not text strings.
If so, try changing the formula to =TEXT(C7,"dddd") and fill down, to see if that makes a difference.
See the attached version.
Hans...you are the man!!!
I really did try the formula you sent over last, seriously. Regardless, yours worked beautifully!
Douglas