Forum Discussion

Pratichi's avatar
Pratichi
Copper Contributor
Aug 05, 2022
Solved

Excel formula: Identifying no.of task happening in a different month

Hi all, I am working on a project where you have Tasks separated into workstreams and have a start + end date. This allows be to get a gant and all, but I need to be able to show by workstream lead...
Charting
excel
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Aug 05, 2022

    Pratichi 

    Try COUNTIFS() function with date criteria like- (download the attach file).

     

    =COUNTIFS($C$2:$C$9,"<="&F3,$D$2:$D$9,">="&F3,$B$2:$B$9,"IT")

     

     

Harun24HR's avatar
Harun24HR
Bronze Contributor
Aug 05, 2022
So, starting and ending months also will be counted as ongoing month? Can you put your desired output to 2nd table manually so that we can try to achieve that by formula.
  • Pratichi's avatar
    Pratichi
    Copper Contributor
    Aug 05, 2022
    I've added the desired outcome on the initial post.
    • Harun24HR's avatar
      Harun24HR
      Bronze Contributor
      Aug 05, 2022

      Pratichi 

      Try COUNTIFS() function with date criteria like- (download the attach file).

       

      =COUNTIFS($C$2:$C$9,"<="&F3,$D$2:$D$9,">="&F3,$B$2:$B$9,"IT")

       

       

      • Pratichi's avatar
        Pratichi
        Copper Contributor
        Aug 05, 2022
        Thanks Harun24HR, it works 🙂

Resources