Dashboard - Formula help for date fields

dcabras

Hi

I have a column in my sheet that is date specific. I am trying to bunch together how many actions have taken place within each month. E.g. if I have 5 actions, one per line, that have been executed within the month of May (all different dates) please can someone provide the formula that will allow me to make a count of how many actions for May?

The eample attached, shows 5 actions that have been executed in May. On my dashboard I want to show 'Offers Accepted in May' to generate the count of 5.

Paul Newcome

Try something along the lines of this (either on the same sheet in a different column or in a different sheet using cross sheet references):

 

=COUNTIFS([Offer Accepted date]:[Offer Accepted date], IFERROR(MONTH(@cell), 0) = 5)

 

Just change the 5 to whatever month number you need. If you currently or will eventually have multiple years on the same sheet and want to specify that portion as well, it would look like this:

 

=COUNTIFS([Offer Accepted date]:[Offer Accepted date], AND(IFERROR(MONTH(@cell), 0) = 5, IFERROR(YEAR(@cell), 0) = 2019))

 

and then just change 2019 to the correct year.

dcabras

Thanks so much Paul! This worked perfectly!

Paul Newcome

Happy to help!