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")

     

     

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