Hi,
I would like to count the number of days a job has been posted according certain criteria - <35days, 36-60 days, 61-90 days and by department (legal, finance, HR).
I have the formula in the <35 days column, and a formula that doesn't work for the others.
In addition, I am trying to count working days only.
I have attached a file for reference.
Thank you.
Brandy
Bookmarks