I have created a equation that counts cells in column E containing "Central" if any cell in column B date has the date 23 of jan 2017 and any cell in column F has Telepower.
the equation works at the moment for a specific date.
=COUNTIFS(B:B,"1/23/2017",F:F,"Telepower",E:E,"Central")
What i what to do now is input a date on Cell A1 and what ever date i put on A1 should be used in the equation in place of 1/23/2017
how can i input this into the equation to pull the date from cell A1
Bookmarks