myletterboxnp
New Member
- Joined
- May 20, 2022
- Messages
- 28
- Office Version
- 365
Hi there,
Sheet1:
A2:A100 =name of applicants
C2:C100 =Position candidates applied for
E2:E100 =Date candidates applied for the job
Sheet 2:
B19 =start date (eg. 5/1/2022)
B20 = end date (eg. 5/31/2022
B2:B100 has different job positions. (Eg. B2=Massage Therapist, Guest Service Agent,.....)
After I enter a date range in B19 and B20, what should be the formula let's say in G2 cell to count the total number of candidates who had applied for a particular position within that date range for that particular position?
What should be the formula in G2 cell?
Thank you for your help.
AR
Sheet1:
A2:A100 =name of applicants
C2:C100 =Position candidates applied for
E2:E100 =Date candidates applied for the job
Sheet 2:
B19 =start date (eg. 5/1/2022)
B20 = end date (eg. 5/31/2022
B2:B100 has different job positions. (Eg. B2=Massage Therapist, Guest Service Agent,.....)
After I enter a date range in B19 and B20, what should be the formula let's say in G2 cell to count the total number of candidates who had applied for a particular position within that date range for that particular position?
What should be the formula in G2 cell?
Thank you for your help.
AR