I am using “Student Assignment Planer” Templet from Excel.
Question regarding function.
When I enter the assignment due date on assignment tab, I can see “Assignment due!” on Monthly tab.
Instead of Assignment due! Sign, I want to populate what is the assignment.
Can you please help me?
FYI, this is the function on the cell;
=IF(LEN(G18)=0,"",IF(COUNTIF(Assignments[DUE DATE],DATE(MoYear,MoMonthNum,G18))>0,"Assignment due!",""))
Solved by X. E. in 28 mins