Forum Discussion
Excel Table Formula Help Needed
Good evening. I have an Excel table that was built by someone else that is nearly perfect, but I need it to do one more thing if the capability exists. It is a table with columns using yes/no cho...
If modify a bit and take into account only number of Admit dates in the period
=COUNTIFS(Table_Intake[Ordered on Weekend],"yes",Table_Intake[Admit Date],">="&$B$1,Table_Intake[Admit Date],"<="&$B$2)/COUNTIFS(Table_Intake[Admit Date],">="&$B$1,Table_Intake[Admit Date],"<="&$B$2)
