Looking up dates against statuses

[RED12345]

Hi guys

I'm hoping someone can help as this is driving me nuts!

I'm creating a recruitment tracker and i've almost finished, however I'd like to be able to search on statuses by dates.

I.e. how many interviews happended w/c 29/02/18, how many roles we're filled w/c 29/02/18, how many roles were advertised w/c 29/01/18? I've attached a basic mock up to show what I mean - hopefully i'm making sense! Tanks for any help in advance :-)

Excel Example.png

[TMS]

See duplicate thread: https://www.excelforum.com/excel-gen...-statuses.html