I am trying to create a countif formula with multiple criteria with one being the approval status and the other being scheduled (which is a date and I want to count it as "1").
I'm trying =countifs(range1, "Approved") +countif(range 2, ???)
The question marks if where I am having issues. The