Dates beyond end of year

[gpc1]

Hi All

Im using the below formula to count the number of projects due to go live each month. But cant seem to work it out for months beyond December.

=SUMPRODUCT(1*(MONTH('Live Changes'!$I$4:$I$13)=2))

The Column headings are Jan / Feb etc


Any help much appreciated

[David A Coop]

Hi gpc1,

Welcome to the forum.

This formula will count every date in the range I4:I13 which is in February. The year should have nothing to do with anything.

Are all the column headings actually dates? If you have used TEXT for any of the column headings, your formula will not pick it up. For example, if you have entered 1/2 to get Feb as the column heading in one place, and "Feb" in another, you will only get the date counted.

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[Aardigspook]

I assume you mean that you want to count (for example) projects for Feb 2018 separately from Feb 2019, etc.
You could add another condition to your formula to check the year - something like this:

Please Login or Register  to view this content.

[David A Coop]

Good point Aardigspook!

I think you could take it one step further by entering the date in, say, A1.

Please Login or Register  to view this content.

This way, you don't have to constantly edit the formula, but simply change the date in A1.

Of course, you could have a whole range of dates to count, and copy the formula down.

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".