Welcome!

Countif comparing months in a date

I'm trying to figure out a countif formula to count up the number of times dates in 2 columns are not in the same month but struggling to figure it out. Can anyone help?

I've attached a screen shot to show bit more clearly what I mean. Basically I want a count to show the number of times things were not prepared and submitted in the same month - so that I can figure out how many times prep spanned over one month in to another. Is this possible? Note, my dates are in the UK format of DD/MM/YYYY.

Thanks

Find more posts tagged with

Comments

Paul Newcome

The easiest way would be to create a helper column. For this example I will use a Flag/Symbol type column to flag the row if the months for the two dates do not match.

=IF(MONTH([In Prep]@row) <> MONTH(Submitted@row), 1)

This will flag the rows where the months don't match, and then you can use a basic COUNTIFS on the helper column to count how many rows are flagged.

=COUNTIFS(Helper:Helper, 1)

Sign in to join the conversation!

Quick Links

Trending discussions

Slow loading
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑
Report that includes multiple sheets
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
Revise Filter in Dashboard
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?