Hi,
I would like to know how many days a job has been open (ie. posted) up to today's date within a department. I have 3 column headings and 3 departments:
------------- <35 Days----36-60 Days----61-90 Days
Depart. 1
Depart. 2
Depart. 3
If the position has been open for <35 days a count for that job goes into that column. If it's been open between 36-60 days a count goes into that column, etc.
There could be multiple jobs open within each department.
What should the formula be for this? In addition would it be possible to count only the working days?
Thank you.
Mellon
I would like to know how many days a job has been open (ie. posted) up to today's date within a department. I have 3 column headings and 3 departments:
------------- <35 Days----36-60 Days----61-90 Days
Depart. 1
Depart. 2
Depart. 3
If the position has been open for <35 days a count for that job goes into that column. If it's been open between 36-60 days a count goes into that column, etc.
There could be multiple jobs open within each department.
What should the formula be for this? In addition would it be possible to count only the working days?
Thank you.
Mellon