Fix Excel Formula : Count If formula that will populate with some conditions

Status: Closed
Prize: $10
Entries Received: 17

Contest Brief

I need to have a Count If formula that will populate with some conditions. Can anyone help me to fix this?

Logic: If the date on A:A (Staff List - On Board) is not equal to EOMONTH, then populate 1st day of the month of the given date, if not, 1st day of next month)- I need to integrate this condition on the Count If formula.

Sample file attached.

Recommended Skills

Post a Contest Like This

Public Clarification Board

regzap
- 6 years ago
Is this some kind of a fake project? It's been 1 week and not a single respond from the project owner.
- 6 years ago
porcupinefish
- 6 years ago
Almost all Entry solve the contest holders problem by using countifs, and this is the easier way to do it, including me. But all the entries' formulas will not calculate the correct "Mobility Planning", except my Entry #19 , when there are more than 2,3 ... set of dates... Please correct me if I was wrong...
- 6 years ago
SureshXobos
- 6 years ago
You can hide the columns if needed too.
- 6 years ago
SureshXobos
- 6 years ago
it'd be better if you use a simple vlookup function.
- 6 years ago
Rameez7986
- 6 years ago
Explanation need more precision, logic EOMONTH works with postive and negative intergals...
- 6 years ago
1. regzap
  - 6 years ago
  I don't think there's a need for more explanation. The explanation is already straightforward and problem is actually quite simple.
  - 6 years ago
nadimvicky
- 6 years ago
Please check entry# 16
- 6 years ago
ABGondal1
- 6 years ago
CountIf will not populate the 1st day of the month of the given date or 1st day of next month. It'll only count the number of entries based on the logic. Will you please specify what exactly you want?
- 6 years ago
ABGondal1
- 6 years ago
What do you mean by Countif formula. CountIf will only count the no. of dates based on criteria.
- 6 years ago