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

État: Closed
Prix: $10
Propositions reçues: 17

Résumé du concours

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.

Compétences recommandées

Publiez un concours comme celui-ci

Tableau de clarification publique

regzap
- il y a 6 ans
Is this some kind of a fake project? It's been 1 week and not a single respond from the project owner.
- il y a 6 ans
porcupinefish
- il y a 6 ans
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...
- il y a 6 ans
SureshXobos
- il y a 6 ans
You can hide the columns if needed too.
- il y a 6 ans
SureshXobos
- il y a 6 ans
it'd be better if you use a simple vlookup function.
- il y a 6 ans
Rameez7986
- il y a 6 ans
Explanation need more precision, logic EOMONTH works with postive and negative intergals...
- il y a 6 ans
1. regzap
  - il y a 6 ans
  I don't think there's a need for more explanation. The explanation is already straightforward and problem is actually quite simple.
  - il y a 6 ans
nadimvicky
- il y a 6 ans
Please check entry# 16
- il y a 6 ans
ABGondal1
- il y a 6 ans
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?
- il y a 6 ans
ABGondal1
- il y a 6 ans
What do you mean by Countif formula. CountIf will only count the no. of dates based on criteria.
- il y a 6 ans