I'm sorry...I did not know that you responded to my last message. I'm not sure where or how to mark the case solved. I'd appreciate it if you could show me. However, I have one "formula" concern which i hope to get assistance from you. On Sheet 5 of the attached behavior monitoring file, on cell M8, I wanted that cell to display the formula value of C8. However, I wanted the cell to display "NA" if the date on B8 is a saturday or sunday. As you will see, the cells from B6 to V36 gets greyed out if the date on the B column falls on a Saturday or Sunday.
English2 Behavior Monitoring Modified.xlsm
Bookmarks