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.
I would not only be happy to but prefer to.
Dropbox: https://www.dropbox.com/scl/fi/h3r5umuyxefl98q101vbu/PDcalcs221-01_2023_02-02.xlsx?dl=0&rlkey=cn4xy7xkil1lbsl2iy564p383
I think I will need to share this with you which means I think I would need your email address. Maybe we would need to be outside this chat to convey such information?
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