I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month:
=COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY()))
Then I try and modify it to the following for the following month, and then the month after that:
=COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY(30)))
=COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY(60)))
However, none of these are working currently - what am i missing out?
NB: the Tippa JC status is looking up to another sheet to check that the completion date is blank. Tippa Start references the start date on the same sheet that the Tippa JC Status pulls from.