fareedexcel
Member
Hi All,
I need to count between 2 dates (Start Date - Q1 of the Current Year & End Date - Q1 of the Current Year) - 1/1/21 - 31/3/21. The Year should be dynamic as every year the count should be for the respective year but the quarter remains the same. I have 2 scenarios in the attached file.
I have used Countif function but couldn't achieve the desired result. Please help.
I need to count between 2 dates (Start Date - Q1 of the Current Year & End Date - Q1 of the Current Year) - 1/1/21 - 31/3/21. The Year should be dynamic as every year the count should be for the respective year but the quarter remains the same. I have 2 scenarios in the attached file.
I have used Countif function but couldn't achieve the desired result. Please help.